Help compairing system databases

medwardsmedwards Posts: 6
edited September 26, 2006 5:08AM in SQL Compare Previous Versions
For auditing and security reasons I need to establish SQL Server 2000 v8.00.818 "baseline" master and msdb databases on a "secure" instance so I can compare other instances against them.

When I compare the baseline master database with another master database, using SQL Compare 5.2.0.32, only 51 objects are compared.

Any recommendations on how I can get a full compare of system databases?

Thanks
Mike Edwards
· Share on Twitter

Comments

  • medwardsmedwards Posts: 6
    Found the problem. SQL Compare filters out system objects.
    Believe this should be an option.

    While synchronizing system objects is a dangerous thing, being able to report differences in system objects is a very usefull thing.

    If anyone has suggestions, please let me know.

    Thanks
    Mike
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Mike,

    That's indeed something to look into. I found myself wanting to compare two MSDB databases the other week to troubleshoot a problem and didn't get anything back from them.
    · Share on Twitter
This discussion has been closed.