Web Deployment Tool (MS Deploy)
msdeploy to Sql Server requirements?
Last post Aug 07, 2019 09:54 AM by Chris Becke
Aug 07, 2019 09:18 AM|Chris Becke|LINK
I am trying to use the dbDacFx provider in msdeploy to update a SQL server.
It is not clear, in this scenario, if wmsvc is involved and/or how I should setup delegation rules as the database in question, and the connection string I am providing, is to a standalong SQL server.
I have installed Web Deploy 3.6 with the SQL CLR Types, T-SQL Script Dom and Data-Tier Application Framework modules.
When I try execute something like this:
D:\>msdeploy -verb:sync -source:dbDacFx="Server=db1/inst1;Integrated Security=SSPI;Database=example" -dest:auto=%cd%\example.dacpac
I get the error:
Info: Adding MSDeploy.dbDacFx (MSDeploy.dbDacFx).
Info: Adding database (server=db1\inst1;integrated security=SSPI;database=example)
Info: Validating schema: Pending.
Info: Exporting data: Pending.
Info: Extracting schema from database: Pending.
Info: Resolving references in schema model: Pending.
Info: Validating schema model for data package: Pending.
Info: Exporting data from database: Pending.
Info: Extracting schema: Pending.
Info: Extracting schema: Running.
Info: Extracting schema (Start)
Info: Extracting schema from database: Running.
Info: Extracting schema from database: Faulted.
Info: Resolving references in schema model: Faulted.
Info: Extracting schema: Faulted.
Info: Extracting schema (Failed)
Info: Validating schema model for data package: Faulted.
Info: Exporting data from database: Faulted.
Error: Exception has been thrown by the target of an invocation.
Error: Database source is not a supported version of SQL Server db1\inst1: example.
Error count: 1.
The SQL Server version (via Azure Data Studio) is 14.0.3038.14 which is a build of SQL Server 2017 so that doesn't seem to be the problem.
Aug 07, 2019 09:54 AM|Chris Becke|LINK
Running a profile on the DB in Azure data studio I see that it connects and goes through several steps successfully. The final step before it aborts, msdeploy attempts this script:
declare @p2 tinyint
exec sp_dbcmptlevel @dbname=N'conduit ',@new_cmptlevel=@p2 output
When I attempt to execute this script the error that results is "incorrect syntax near the keyword 'default'."