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

Module Signing Support?

Hi, does SQL Compare check databases for differences in relation to module signing?

I ask because comparisons between a database and a scripts folder don't appear to have been identifying that a particular stored procedure in a database had been deployed without being signed, yet the script file contains a statement to sign the stored procedure by a certificate.

e.g.

ADD SIGNATURE TO [dbo].[MyProcedure]
BY CERTIFICATE [MyCertificate]
WITH PASSWORD = 'p@ssw0rd'
GO

I've not seen any options to enable or disable module signing checks so I was wondering whether it was supported.

Thanks
Chris
howarthcd
0

Comments

1 comment

  • DanC
    Hi @howarthcd

    I did some quick testing around this and also checked with the developers and unfortunately, this isn't currently supported.

    My suggestion would be to make a feature request via the UserVoice forum which the team looks at for new feature ideas: https://redgate.uservoice.com/forums/141379-sql-compare
    DanC
    0

Add comment

Please sign in to leave a comment.