We are looking at upgrading some of our SQL 2000 related apps to a SQL 2008 r2 box.
Someone has asked if we can do the following (which I have never tried before)
Take a backup of the SQL 2000 database
Start a trace on the 2000 database
restore the backup on a 2008 server - change compatibility mode etc
replay the trace on the 2008 database
use Data Compare to show the database are the same.
Use this to demonstrate that had the application used the 2008 database they would have had the same data as they would have done having used the 2000 database.
Note: This isn't an attempt to shortcut development or testing – it's an attempt to
View Complete Post