Lynda – Migrating Access Databases to SQL Server

Lynda – Migrating Access Databases to SQL Server
English | Size: 389.93 MB
Category: CBTs

At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server’s advanced features, and maintain a link to the data in Access.

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.

Topics include:
Why upgrade?
Importing a SQL database
Exploring data types and server objects
Installing SSMA
Mapping source and target data types
Using the Migration Wizard
Linking to migrated tables in SSMA
Working with views and stored procedures
Linking Access to SQL Server databases

Buy Long-term Premium Accounts To Support Me & Max Speed


If any links die or problem unrar, send request to

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.

Skip to toolbar