Comparing two Databases

[mukund]

Hi,
Has anybody has written a SP/script that will compare two databases and display the differences between the two databases ?
This will come handy whenever changes from one database are to be effected on the other database.

Regards,
Mukund.

 

[tomschafer]

Follow the link below a couple pages down you will see
"db_Compare.sql - Submitted by: Dan Wunder posted on 5/11/01 (updated on 5/21/01)"

http://www.swynk.com/sqlscripts/maintenance7.asp

You might also see some other things that spark some interest.

 

[mukund]

Thanks Pezamystik,
I got the script, will try it out.

Regards,
Mukund.