is there a tool to see the difference between two database tables in mssql?

Posted by reinier on Stack Overflow See other posts from Stack Overflow or by reinier
Published on 2010-04-22T08:18:54Z Indexed on 2010/04/22 8:23 UTC
Read the original article Hit count: 246

Filed under:
|
|
|

What is a good tool to see the differences between 2 tables (or even better, the datasets returned by 2 queries).

EDIT: I'm not interested in the schema changes. Just assume that the schemas are the same.

background as to why: I'm porting some legacy code which can fill a database with some pre-calced data. The easiest way to see if I got everything right, is to check the output of the old program, with the new one. I was thinking that if there is some kind of 'diff' tool for databases, this might be great.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about diff