|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, May 13, 2009 1:19 AM
Points: 1,
Visits: 48
|
|
Hi,
I want to create a weekly job which will compare the databases of two different instances of SQL Server 2005.
Thanks,
Rahul
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Friday, June 05, 2009 2:01 AM
Points: 690,
Visits: 672
|
|
YOu can think about following third party tool or similar tool:
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 02, 2009 2:43 PM
Points: 243,
Visits: 361
|
|
If you're talking about schema and not data, and want something cheap and easy I have something for you:
try running a checksum_agg(binary_checksum(*)) from the sysobjects, sysusers, sysprotects, and sysmembers files.
If you want details skip the checksum_agg() part and you can see the checksum of every object.
compare with the other table maybe using an SSIS job.
Good luck.
|
|
|
|
