DataBase Comparison

[Bygbobbo]

Does anyone know of a utility that can do a comparison of an entire database to another database?

Both databases have the same infrastructure, but one was archived and one contains new data.

I am looking for some sort of built in utility that can tell me all the differences in each of the tables.


Thanks in advance,
Bygs

 

[sunila7]

Hi,

have a look at this link.

http://www.red-gate.com/sql/summary.htm

We r using SQL Compare 2 databases. Or, Probably u can use script out the databases and use Visual Source safe to compre differences in the 2 DB's


Hope it helps.

Sunil

 

[SQLSister]

I'm with sunil. SQL Compare is a great tool and it isn;t expensive. Worth it's weight in gold.