1

I've got an Access database from one of our clients and want to import this data into a new MSSQL Server 2008 database structure I designed. It's similar to the Access Database (including all the columns and so on) but I normalized the entire database.

Is there any tool (microsoft tools preferred) to map the old database to my new design?

thanks

Henrik P. Hessel
  • 400
  • 3
  • 18

3 Answers3

2

The current tool of choice is SQL Server Migration Assistant (for the appropriate source database, i.e., comes in Access, Oracle, etc. flavors). But it replicates your Access database structure from scratch, rather than importing the data into your pre-built database.

David W. Fenton
  • 232
  • 1
  • 7
1

You could look at using SSIS (part of SQL Server) which is a comprehensive set of tools for doing ETL.

Chris W
  • 2,670
  • 1
  • 23
  • 32
0

Built into Access is the SQL Upsize Wizard. You can use that - read up on it for all the details, but you should be good.

mfinni
  • 35,711
  • 3
  • 50
  • 86
  • SSMA is signifcantly better than the SQL Upsizing Wizard built into Access. – Tony Toews Sep 08 '10 at 05:20
  • A few days ago I posted my observations on using SSMA (http://www.accessmonster.com/Uwe/Forum.aspx/databases-ms-access/44398/SSMA-for-Access-4-2-Observations -- it's not on Google Groups for some reason), and today discovered it failed to upsize one of the relationships, even thought that relationship was present in the source database. So, you need to check the results REALLY CAREFULLY. – David W. Fenton Sep 08 '10 at 20:25