Join Adam Wilbert for an in-depth discussion in this video Using the exercise files, part of Migrating Access Databases to SQL Server.
- If you're a premium subscriber to the lynda.com online training library, then you have access to the same exercise files that I'll be using on screen. Simply follow the link at the top of the main course page to download them. I'll be working with the files on my desktop here, but you can place them wherever you'd like. I'll go ahead and double click on this to open it up and you can see that we have individual folders for each chapter in the course. Then inside of each of these chapter folders, I have the individual database files that we'll be working with. Because we'll be connecting to database servers and saving our progress along the way, each chapter will begin with a starting file.
The movies in each chapter will need to be completed in sequence in order to process the exercise files in the same way that I am. Unfortunately, no completed files can be provided since they're highly dependent on the unique machine name, login credentials, and other settings, and will be different for every user. If you don't have access to the exercise files, you can follow along with your own databases. Now, a quick note about Access and its security, whenever you open up a brand new database on your system, you're going to be presented with this yellow security bar across the top of your screen.
You can either choose to enable the content here or add the exercise files to your list of trusted locations. We can do that by going up to the File menu and choosing Options, down here at the bottom. Then going into the Trust Center here and finally, pressing Trust Center Settings, here. Go up to Trusted Locations and we can add a new location, here. After doing that, you'll no longer be bothered by that yellow security warning for each database file Now, let's get started.
Watch this course to learn how to leverage what you already know to take that next step. Adam Wilbert reviews the basics of SQL Server Management Studio (SSMS) and introduces two workflows for migrating Access data: one using a simple export/import process and the other using the free SQL Server Migration Assistant (SSMA). He also shows how to convert Access to SQL data types, link Access to SQL data via an ODBC connection, and address special concerns for Access 2010 data.
- Identify three start modes available on the Service tab.
- Recognize the locations from which databases may be imported.
- Recall which databases are supported by the SQL Server Migration Assistant.
- Explain which types of Access column data are most likely to cause errors during the conversion process.
- Summarize how to create a backup.
- Determine where ODBC Data Sources are located.
- Recognize which table names the SQL Server will wrap by square brackets.