Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Migrate Data from Table to Normalised Tables

Author  Topic  VThou Starting Member 4 Posts Posted - 2009-11-12 : 23:24:22 Hi all, My experiance with SQL is minor and limited to .NET programming. I have been tasked with creating a .NET Web App as a front end to a 'Contact' database. Currently the 'Contact' Db is in Acess format to which I want to put into SQL2008 format. I have 'Imported' the Access single table into SQL2008. I have also created a 'normalised' version of this table resulting in 6 seperate tables (Contact Table --> User, Company, User_Company, Email, Telephone, location Tables). My question is what is the easiest/quickest way to migrate the data from the converted single table to the normailised tables? Is there a GUI tool that allows you to select the source table/column and the destination table/column? I used a MS tool to migrate the Access DB, however it just creates one table and doesnt provide the level of granualarity I need. Am happy to learn the required SQL commands to mannually do (INSERT INTO ?), but was hoping to automate the task as is a once off. TIA