Lynda - Migrating Access Databases to SQL Server

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.

https://www.lynda.com/Access-tutorials/Migrating-Access-Databases-SQL-Server/397389-2.html

Table of Contents

Introduction

1. Getting Started

2. Digging into SQL Server

3. Using SQL Server Migration Assistant

4. Making the Transition

5. Connecting Access to SQL Server Databases

6. Upsizing Access 2010 databases

Conclusion

 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.

 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.

 Coktum   |