How can we help you today? How can we help you today?

SQL Compare and signed stored procedures

Afternoon all,

We've just noticed that when we use SQL Compare (15, latest) it doesn't tell us if the stored procedure in question is signed by a certificate; e.g. something like:

ADD COUNTER SIGNATURE TO [Something] BY CERTIFICATE [ACert] 
WITH PASSWORD = 'ohdear';

So if that's been done one side but not the other we don't see it?

Have we missed an option or is this outside of the way SQL Compare works? I know that signing isn't a property of the SP itself as it were but it is a schema difference - and comparing certificates doesn't tell you that either.

As our current workaround we've created a query where we have all the SP's we know should be signed; we check they are and if not sign them - and run this after each use of SQL Compare; to ensure that these signatures are maintained.

Is there a better way of doing this through SQL Compare?

Thanks!

Dr. Michael Dye.
michaeldye
0

Comments

3 comments

Sort by
  • DanC
    Hi @michaeldye

    Unfortunately, signed Stored Procedures are not supported in SQL Compare.

    If you would like this to be supported, please post on the UserVoice forum here: https://redgate.uservoice.com/forums/141379-sql-compare
    DanC
    0
  • michaeldye
    Brill thanks for clarifying - at least we're not going mad :)


    michaeldye
    0
  • DanC
    Hi @michaeldye

    You're most welcome for the clarification!
    DanC
    0

Add comment

Please sign in to leave a comment.