Is it possible to include system objects in a comparison?

Forum for users of SQL Compare schema synchronization utility

Is it possible to include system objects in a comparison?

Postby dougr » Mon Jan 09, 2012 7: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.


Posts: 1
Joined: Mon Jan 09, 2012 6:53 pm

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

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 Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1150
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests