Importing data from Access to SQL Server (with minor table changes)

Question

I'm currently working on migrating an application from MS-Access to MS SQL Server. In the process, there are a few minor changes that I am making to the table layouts (I am splitting a few things up into more two tables), however, I would still like to keep all the data that is present in the database.

What would be the best way to import the data, while changing the database structure to suit my new requirements?

Answer 1

If you are planning to upgrade a Microsoft Access database to SQL Server 2008, use the SQL Server Migration Assistant (SSMA) rather than the upsizing wizard built into MS Access.

Download from here (Thanks Tony): SQL Server Migration Assistant 2008 for Access