What are the challenges you face when working across database platforms? Take the survey

Compare Jobs and DB Maint Plans

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 7, 2003 11:08AM in SQL Compare Previous Versions
Hi Jeb,

Thanks for writing. SQL Compare filters out all system tables
automatically. Comparing and synchronizing these tables is probably not a
very good idea. Updating these tables is best left to the server to avoid
corrupting the database completely.

Now that you mention it, Red Gate does make a tool for comparing DTS
packages, jobs, logins and the like called DTS Compare. You can't
synchronize them (again, probably for the same reasons mentioned above!),
but you can get a quick grip on where the differences are.


Brian Donahue

Red Gate Technical Support

"jeb" <jeb.beasley-@-nospam-berksnet.com> wrote in message
> I realize that tables without unique key can not be compared, however
> some tables in SQL Server msdb have a primary key based on a 'unique
> identifier' type. Why can't I select the following tables for data
> comparison?
> dbo.sysdtscategories, dbo.sysjobs, etc?
> I would like ot insure DTS packages, maintenance plans, and jobs are
> identical.
> Thanks
> Jeb
This discussion has been closed.