Is it possible to include system objects in a comparison?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Is it possible to include system objects in a comparison?

Postby dougr » Mon Jan 09, 2012 8:02 pm

Hi -

I have a number of common stored procedures that I have added to the master database and then marked with EXEC sys.sp_MS_marksystemobject sp_MySproc so that they are available to all databases on the server.

Is there a way to do this? I checked under the project options along with trying the filters but could not find a way to do this.

If not, it would be great if there was new option under the "Ignore" section of the project options that was selected by default but could then be removed to see the system objects in the database.

Thanks.

Doug
dougr
 
Posts: 1
Joined: Mon Jan 09, 2012 7:53 pm

Postby eddie davis » Wed Jan 11, 2012 9:17 pm

Hi,
Thank you for your post into the forum.

SQL Compare does not compare system objects.

Therefore I have added the details of this forum post for SQL Compare to compare system objects and system databases to an existing feature request.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest