Home / server / Questions / 127281
Accepted
Henrik P. Hessel
Asked: 2010-03-30 05:12:50 +0800 CST

Transform data to a new structure

  • 772

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

sql-server microsoft-access

3 Answers

  1. 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.

    • 2
  2. Best Answer

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

    • 1

  3. 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.

    • 0