I don't know of a tool or process that does this for you, you will need to take the relevant data from the non-nz table and use insert statements into the new tables...
http://www.w3schools.com/sql/sql_select_into.asp
Please remember to Mark As Answer if helpful
Regards, Christiandev (@chrisdev80), MCPD Web (2 & 4) & MCTS Windows (www.ScoreDonkey.com)
vaibhav_shah...
Member
402 Points
113 Posts
Migrating data from non-normalizes table to multiple normalized tables
May 26, 2012 11:14 AM|LINK
Hi,
I had one non-normalized table.
I made 4 normalized tables form it.
Now i want to transfer data from that non-normalized table to this tables.
I reallt dont know how can we do it
Click Here For More Answers
rageshS
Member
664 Points
319 Posts
Re: Migrating data from non-normalizes table to multiple normalized tables
May 26, 2012 11:21 AM|LINK
please look this link
http://www.devx.com/tips/Tip/17059
christiandev
Star
8597 Points
1841 Posts
Re: Migrating data from non-normalizes table to multiple normalized tables
May 27, 2012 10:40 AM|LINK
Hi,
I don't know of a tool or process that does this for you, you will need to take the relevant data from the non-nz table and use insert statements into the new tables...
http://www.w3schools.com/sql/sql_select_into.asp
Regards, Christiandev (@chrisdev80), MCPD Web (2 & 4) & MCTS Windows (www.ScoreDonkey.com)
Chen Yu - MS...
All-Star
21569 Points
2493 Posts
Microsoft
Re: Migrating data from non-normalizes table to multiple normalized tables
May 28, 2012 08:53 AM|LINK
Hi,
It seems they have relationship between those tables. You could follow that relation to insert corresponding tables.
If you need some sugguestion about your insert query, please post your one non-normalized table and 4 normalized tables.
Thanks.
Feedback to us
Develop and promote your apps in Windows Store