Module Signing Support?

howarthcd

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

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