FOR THOSE OF YOU who have an Access database, but would like to migrate it to SQL Server 2005, this handy little utility from Microsoft will do the job. It’s a free download, and blogger CF Payne has made a list of step-by-step instructions for using it.
Read the post (no longer available) Download the Instructions (Word Doc) (no longer available)
SSMA (Microsoft SQL Server Migration Assistant for Access) “converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server.”
It will convert Access 97 – 2003 databases. Works on Windows 2000, Windows Server 2003, and Windows XP.
You’ll need to register with Microsoft to get a key to unlock the program. You will also need the Microsoft .NET Framework 2.0 (or later), J# 2.0 redistributable package, Windows Installer 3.1 (or later version), 1 g of RAM, and access to the SQL Server host computer.
Links to these programs, plus more information and the SSMA download link can be found on Microsoft’s SSMA page (no longer available).
Did I mention that it is free?