We are decommissioning our old SQL Server 2000 Ent. instance in favor of SQL Server 2008 R2 Ent. My planned migration path is:
- Terminate client connections (2000)
- Full Backup (2000)
- Restore (2008 R2)
I am being asked to provide conclusive proof that every single transaction "made it" and that the data is an exact replication of what existed on the 2000 instance.
I hope that I can use the following documentation as evidence:
However, if this is not sufficient, the only thing I can think of is to rip through ever row of every table of every database and calculate a checksum (on both instances) as well as get row counts for every table in every database.
Is there any better way to satisfy the "exact replica" verification criteria? I'm also open to better documentation.