August 21, 2005 at 11:25 pm
Hi all,
We have migrated MS SQL 7 to SQL Server 2000 databases using DTS.
Any idea on how to do the Data verification for this?. Also it would be of help if you could let me know the possibility of other differences that can happen when it is migrated from MS SQL 7 to SQL Server 2000.
Thanks and Regards,
Sathya.
August 23, 2005 at 8:27 am
To simply check row counts, you can run the following against version 7 and then 2000 and compare the results.
select o.name as "Table Name",i.rows as "Row Count"
from sysobjects o, sysindexes i
where i.id = o.id
and indid in(0,1)
order by i.rows DESC
Other than that, you should run reports from your app to compare the results/integrity of the data. I guess it depends on what the data is (is it business critical?). I've migrated multiple databases and haven't run into any issues but before migrating, we always had a game plan to verify the results.
Terry
August 24, 2005 at 4:35 am
Be sure your idenitity fields are still identity fields, also your timestamp fields.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply