SSDT Schema Comparison for Stored Procedure signed by a Certificate
3
votes
1
answer
1153
views
I am using SSDT 14.0.50730.0 in Visual Studio Professional 2015. I am comparing databases between two instances and it is finding that there are stored procedures that do not match with regard to their signatures.
In both instances, the Certificate was created in each instance from the same script and the signatures were also added by CERTIFICATE with a PASSWORD using the same script in each instance.
However, Schema Comparison is showing the procedure in both the source and target as having a CERTIFICATE with a SIGNATURE with Signature values that do not match.The generated publish script drops the SIGNATURE BY CERTIFICATE, modifies the procedure, and then adds a SIGNATURE BY CERTIFICATE WITH SIGNATURE. The signature value matches what was shown in the source instance. However, the script fails with the message "The signature of the public key is invalid."
What do I have to do to get these procedures in sync?
Asked by Mark Freeman
(2293 rep)
Dec 7, 2015, 10:12 PM
Last activity: Dec 9, 2015, 03:56 AM
Last activity: Dec 9, 2015, 03:56 AM