What are the challenges you face when working across database platforms? Take the survey
Options

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
Tagged:

Answers

Sign In or Register to comment.