SQL Server Performance Forum – Threads Archive
Normalization
HI dear DBA’sI have an issue with database normalization,i migrated some old database of oracle to SQL Server and now i want to normalise the database design into more relational. How can i split the tables into many without losing my data? I have doubt that if i split into many tables how does the data which is already in the database is arranged into my new design?
the only way split the tables into many is to use select and insert or update to the new table. Example<br />Tables<br />id c1 c2 c3 c4<br />1 a b c d<br />2 d e f g<br /><br />table1<br />id c1<br />1 a<br /><br />table2<br />1 b<br /><br />etc<br /><br />insert into table1 (id c1) select id, c1 from tables and so on. <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /> good luck lots of works<br /><br />May the best cheaters win
I would suspect that there are third-party tools available that can assist you in your task. Maybe you find something here in the Tools section. Anyway, this is a labour-intensive and no trivial task. You might think more than once about how to tackle this problem. But it surely pays! Good luck! —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
A few goodies:
http://www.sql-server-performance.com/database_design.asp
http://www.sql-server-performance.com/book_excerpts.asp
http://www.sqlteam.com/item.asp?ItemID=122 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Few more
http://sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=7&faqid=10
http://www.sqlservercentral.com/columnists/bkelley/normalization.asp
http://www.tdan.com/sms_issue31.htm
tdong is right…the only way is to map out the conversions from the existing tables to the new ones, and have a whole lot of insert statements from the old to the new…and Frank is right too, it is very labour intensive (i am doing it at the moment…maybe i should mention it can become tedious or even boring too <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />)<br /><br />Good luck with it!<br /><br />’I reject your reality and substitute my own’ – Adam Savage
]]>