CODEWITHSUNDEEP
sqlsql-serversql-server-2005
Slee
Slee

Reputation: 28248

compare 2 different databases table columns

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

Upvotes: 4

Views: 1020

Answers (5)

mevdiven
mevdiven

Reputation: 1902

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.

Upvotes: 0

apros
apros

Reputation: 2878

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

Upvotes: 1

Mikael Eriksson
Mikael Eriksson

Reputation: 138960

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

Upvotes: 0

dcarneiro
dcarneiro

Reputation: 7150

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)

Upvotes: 0

Joe Stefanelli
Joe Stefanelli

Reputation: 135809

redgate SQL Data Compare

Upvotes: 4

Related Questions