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

views:

answers:

+2 Q:

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

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?

+2 A:

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

SQLMenace 2010-03-03 02:22:25

The upsizing wizard is always behind SQL Server versions, so the SSMA is almost always a better choice.

David-W-Fenton 2010-03-04 19:55:31

+4 A:

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 V4.0

Mitch Wheat 2010-03-03 02:22:44

Tony Miller 2010-03-03 02:24:16

Thanks, that looks like it will solve my problems for me.

a_m0d 2010-03-03 02:33:58

ansaurus

tags:

views:

answers:

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

related questions