From the course: Migrating Access Databases to SQL Server

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Preparing to upsize

Preparing to upsize

From the course: Migrating Access Databases to SQL Server

Start my 1-month free trial

Preparing to upsize

- By now you've seen several ways that you can combine an Access front end with a SQL Server back end. We're going to make a little shift here and talk about one additional resource that's only available if you're running Access 2010 or earlier. I'm currently working in the Kineteco-Upsizing Database that can be found in your Chapter 6 folder. But as you might notice, I'm in the older version of Access here: Access 2010. If I switch to the Database Tools Tab, you'll notice one additional option that's not available in 2013 and it's in the Move Data Section, it's this SQL Server Button right here. This will run the tool called The Upsizing Wizard. But before we run through this tool, I want to make sure that we've performed some preliminary steps first. As always when migrating data, you want to verify that your table names don't use any reserved words that appear in the SQL Server Listings. If you need to review what those are, you can find them with a simple Web search for: SQL…

Contents