SQL Compare and signed stored procedures

michaeldye

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.

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

michaeldye

Brill thanks for clarifying - at least we're not going mad

DanC

Hi @michaeldye

You're most welcome for the clarification!