Microsoft Access to SQL Server Migration

On most Access application development road maps is the point at which Access data needs to be migrated to SQL Server for various reasons often related to performance or ability to make data available on the web or integrated with other systems.

There are a number of methods to achieve this which often differ due largely to the version of Access and or SQL Server you are using at the time of a migration.

We ran into a few roadblocks recently for a migration project in terms of lack of built-in migration tool availability for the version of SQL Server we were involved with and although the old-fashioned, manual (create table, import data) approach is always a last resort, the Microsoft SQL Server Migration Assistant is the tool we used and would highly recommend it for your next migration project. It includes a number of nice options such as automatically carrying forward Access Autonumber fields as Identity columns in the resulting SQL Server tables.