compare 2 different databases table columns

I need to compare DB tables from 2 different DB's to see where the d开发者_如何转开发ifferences lie, is there a simple tool or script for this?

redgate SQL Data Compare

It also possible with a Visual Studio Team Edition for Database Professionals 2005/2008 or Ultimate 2010. More details you can find on MSDN

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

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

AdeptSQL Diff to compare structures of database/tables http://www.adeptsql.com/

RedGate Data Compare is the one... Look no further. Once you start using you can't use any other tool. I'm not affiliated with this company, I'm just a fan of their product suite.