Introduction
Welcome
()
What you need to know
()
Using the exercise files
()
1. Getting Started
Understanding front ends and back ends
()
Benefits of a SQL Server back end
()
Understanding SQL Server editions
()
2. Digging into SQL Server
Installing SQL Server Express 2014
()
Starting and stopping SQL Server
()
Using SQL Server Management Studio
()
Importing a SQL database
()
Understanding SQL Server data types
()
Importing SQL Server objects
()
Editing the table design in SSMS
()
3. Using SQL Server Migration Assistant
What is SQL Server Migration Assistant?
()
Downloading and installing SSMA
()
Creating the empty SQL Server database
()
Preparing the Access database
()
Setting default SSMA project options
()
Mapping source and target data types
()
Identifying the Access objects to migrate
()
Creating an SSMA project
()
Creating an assessment report
()
Fixing common migration errors
()
Running the SSMA project
()
4. Making the Transition
Backing up the database
()
Using the SSMA Migration Wizard
()
Exploring the results in SQL Server Management Studio
()
Exploring the changes to Access
()
Relinking tables after structural changes
()
Linking new SQL tables from a production database
()
5. Connecting Access to SQL Server Databases
Linking to ODBC databases
()
Attaching the SQL database
()
Creating the data source
()
Establishing the table links in Access
()
Adding records to linked tables
()
Linking to SQL Server views
()
6. Upsizing Access 2010 databases
Preparing to upsize
()
Using the Upsizing Wizard
()
Editing tables
()
Migrating queries
()
Ex_Files_AccessDB_SQLServer.zip
(5.9 MB)
Glossary_MigratingAccessDatabasestoSQLServer.zip
(102 KB)