August 28, 2003 at 12:38 am
I need some help on migrating data from a de-normalized SQL 2000 database with 150 tables to a SQL 2000 normalized database with over 250+ tables. The de-normalized DB is a Live production database and the normalized DB is our new Web based version of our application.The production database only has primary keys, no foreign keys so all relations are base on the Primary keys. The project is to create a migration that will migrate one Agency at a time to the new database over 6mths.
What is the best way to do this? DTS? Store procedures???
Should I scrub the data first into a staging database?
How do I transfer the relations if I'm taking one table and spreading it over 10? or taking columns from 3 or 4 tables and creating one table?
Getting a Headache just thinking about it! It would be much appreciated if you could point me in the right direction.
Thanks
August 28, 2003 at 12:57 am
quote:
What is the best way to do this? DTS? Store procedures???Should I scrub the data first into a staging database?
Using a staging database is a must I feel.
I am not sure whether using DTS outright, will help you. Recently I had to perform a similar exercise and I had to resort to writing customised stored procdures.
quote:
How do I transfer the relations if I'm taking one table and spreading it over 10? or taking columns from 3 or 4 tables and creating one table?
Again this seems to be a time consuming activity and would depend upon how the new web based application has been designed.I would like to know the strategy you follow so that I can include them in my future endeavours.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply