Hello all!
I am changing the collation on the database and doing a DTS package to copy all of the tables from one database to another. Can someone help with the script that can then (once DTS is done) compare row counts between the new and old database? Maybe just show the diferent tables or at least have that option. We have 5000 tables and manual comparison is not practical at this time as we are at the time crunch.
Thanks, George
I am changing the collation on the database and doing a DTS package to copy all of the tables from one database to another. Can someone help with the script that can then (once DTS is done) compare row counts between the new and old database? Maybe just show the diferent tables or at least have that option. We have 5000 tables and manual comparison is not practical at this time as we are at the time crunch.
Thanks, George