compare databases on different machines? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

compare databases on different machines?

1.How do I compare databases, userd,logins,permissions between 2 sql server2k running on different machines?
Is any sp available which will compare the two servers and give a detail report.If any row in any table in any db mismatches it should genarate the necessary error.
I suggest 3rd party tools, like Red Gate Compare.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.