We are decommissioning an older server (2000) and are in the process of migrating all the DBs to a nice new server (2005).
One particular database was backed up and restored to the new server, BUT not all applications were re-pointed at the instance on the new server, they were left pointing at the old instance on the old server.
Result: We have almost an entire day where some data was inserted into one DB, and some data was inserted into another.
I've been handed the task of getting the data that went to the old server onto the new one.
I've re-backed up the Db and restored it as a separate instance on the new server and I've been able to compare the two.
The "old" instance has about 675 records I need to get onto the new instance.
1. Trying to avoid writing a separate query for every single table in the DB, comparing the old and new instances, and inserting. "IS NOT IN" or something similar. I could do that but I'm swamped with work. This project was NOT
on my to-do list yesterday, but lots of other stuff was. Anything quicker available?
2. Identity: Since the new instance took up where the old instance left off, and the old instance carried on as if nothing had changed, almost every row in every table has PKs duplicated in the other instance, but relating to a different data set.
Besides shooting the individual
View Complete Post