Wednesday, March 21, 2012

Migrate MS Access to SQL Server Express 2005

I have a database in MS Access that I would like to migrate to SQL Server Express 2005. How do I do this? Is there a software I need to download?Access has an upsizing wizard (Tools -> Database Utilities -> Upsizing Wizard). Select option button for creating a New database. Specify the Sql Server name as <your machine name>\SqlExpress, give the new database a name, and you should be good to go. Of course, you'll want to have installed SqlExpress and probably the Express Manager before migration. It worked well for me.

Rick

No comments:

Post a Comment