October 17, 2008 at 12:41 am
Hi,
I want to create a weekly job which will compare the databases of two different instances of SQL Server 2005.
Thanks,
Rahul
October 17, 2008 at 7:22 am
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."
October 17, 2008 at 1:35 pm
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.
Craig Outcalt
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply