Data Conversion advice needed
Hello. I've just joined this forum as I've been searching for some advice with a data conversion that I have to do.
Using : MS SQL server 2000
Old DB: many tables and no relationships originally. They were added afterwards and before my time here.
New DB: Contains all the tables from the Old Db plus quite a few more new tables. Has proper relationships between tables. Has test data only.
As an example of what kinda a changes happened:
Location used to Belong to an Organization directly, now Location belongs to a Region which belongs to an Organization.
The above is just one instance and there are a few more changes that resemble the example above.
My Problem:
I have to get the real data from old db and insert it into the new db.
What would be the best way to go about doing this, keeping in mind that there are many tables in the new db that the old db doesn't "know" about.
in the example i provided, if the region table was empty I could not insert anything into Location or Organization tables.
I'd much appreciate any advice
Thank You. :)
Using : MS SQL server 2000
Old DB: many tables and no relationships originally. They were added afterwards and before my time here.
New DB: Contains all the tables from the Old Db plus quite a few more new tables. Has proper relationships between tables. Has test data only.
As an example of what kinda a changes happened:
Location used to Belong to an Organization directly, now Location belongs to a Region which belongs to an Organization.
The above is just one instance and there are a few more changes that resemble the example above.
My Problem:
I have to get the real data from old db and insert it into the new db.
What would be the best way to go about doing this, keeping in mind that there are many tables in the new db that the old db doesn't "know" about.
in the example i provided, if the region table was empty I could not insert anything into Location or Organization tables.
I'd much appreciate any advice
Thank You. :)