Compare 2 different columns of a database table

Question

I need to compare database tables from 2 different databases to see where the differences lie, is there a simple tool or script for this?

Answer 1

redgate SQL Data Compare

Answer 2

This is also possible with Visual Studio Team Edition for Database Professionals 2005/2008 or Ultimate 2010. You can find more information on MSDN

Answer 3

if you want to compare missing lines you can do something like this

select id from db1.dbo.table1 where id not in (select id from db2.dbo.table2) 

Answer 4

AdeptSQL Diff for comparing database / table structures http://www.adeptsql.com/

Answer 5

RedGate Data Compare is one ... Look no further. Once you start using, you will not be able to use any other tool. I am not an affiliate of this company, I am simply a fan of their product.