Compare Jobs and DB Maint Plans

Brian Donahue

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.

Yours,

Brian Donahue

Red Gate Technical Support

"jeb" <jeb.beasley-@-nospam-berksnet.com> wrote in message
news:3FA9B415.4020005@-nospam-berksnet.com...
>
> 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
>