TSD7025: Unable to identify the schema type contained in the .sql file. A schema type of 'Certi
I have a file ending in cert.sql and it contains a valid CREATE CERTIFICATE statement:
CREATECERTIFICATE [xxxx] AUTHORIZATION[dbo] WITHSUBJECT =xxxx, START_DATE ='2007-01-01T00:00:00', EXPIRY_DATE ='2020-01-01T00:00:00' ACTIVEFORBEGIN_DIALOG =ON |
|
Even though, I get the following error during build:
| Error 1 TSD7025: Unable to identify the schema type contained in the .sql file. A schema type of 'Certificate' was expected, based on the name of the .sql file. ....WZBLMessenger.Client.Service.Cert.sql |
|
Can someone tell me what kind of schema/statement is expected?
Ok, it looks like in a previous CTP Certificates were supported as objects, this is no longer the case. In order to get your certificate into the build script you should add it to your pre-deployment scripts. There is a specific pre-deployment script in there for Certificates, EncryptionKeysAndCertificates.sql. Now, If you didnt import your schema from an existing Database, the include for the EncryptionKeysAndCertificates.sql file wont be in the Script.PreDeployment.sql script, so just add
:r .\EncryptionKeysAndCertificates.sql to Script.PreDeployment.sql. and you should be good. Also note that your subject value needs single quotes around it.