how to compare to databases

[shanghai2004]

Dear Experts,

With your help, I successfully used BCP to export data to files(csdata files) from all tables in a database(collation is case sensitive) and then import the csdata files to another database(collation is case insensitive).
Now I need to verify that the data in both databases are the same.
I compare the number of rows in each table. It was done successfully.
Then what I did is export data to files(cidata files) from case insensitive database, then I use Dos command COMP to two compare csdata file with cidata files. More than 90% tables are ok. But a few tables have problems with the order of rows. It is very time consuming by check those tables to verify that it is not data problem but orders. Is there a easy way to compare two databases?
Help please!

Thanks

 

[SQLDenis]

Download a 14 day trial version of redgate's data compare
and you are set
we have a couple copies of their whole toolset and it's a life saver

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/