The SQL Server Migration Assistant for Access

There is an alternative to using the Upsizing Wizard: the SQL Server Migration Assistant for Access (SSMA), a free Microsoft download, at www.microsoft.com/sql/solutions/migration/ access/default.mspx.

Compared with the Upsizing Wizard, SSMA has a more modern look and includes a number of extra features, but as far as the basics are concerned, it should accomplish the same task: converting Access tables to SQL Server tables. However, at this time the SSMA does not support the new Access 2007 .accdb database format, so if you attempt to use this utility to upsize an Access database to SQL Server, you will just get a message saying "Unrecognized database format."

Using Access as a front end to SQL Server is a topic worthy of a complete book on its own, but the Upsizing Wizard will at least help with the first steps toward creating a client-server application: moving your data from Access tables to SQL Server tables.

0 0

Post a comment