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.
| Author |
Topic |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2009-08-12 : 04:58:06
|
| Hi,I need to import data from one database to another. The structures of the databases are different. Once that is done than after a week or so i have to go back and compare the data in the 2 dbs to see if new data was added to the old db during this period. Maybe product x was updated.I have to see if data for product x in the old db matches the data for product x in the new table.If it doesn't match i have to write out the information in a log file but not update the new database.What is the best tool to achieve both migration and comparison?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-14 : 04:54:51
|
| With different database structures, it will be more effort to compare.Can you create views in the original database to match the new structure?Then you can export the data in the required format to the new tables.And after a week, compare the view data to the table.You can use 3rd party tools for the data comparison - most will script out the differences as sql statements too. |
 |
|
|
|
|
|
migration and comparison