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.