Importing data from Access to SQL Server (with min

问题:

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?

回答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

回答2:

use the upsize wizard in Access to move all your tables and data into SQL Server and then do you table changes there