Is it possible to include system objects in a comparison?

dougrdougr Posts: 2
edited January 11, 2012 3:17PM in SQL Compare Previous Versions
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

Comments

  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.