msdeploy to Sql Server requirements?RSS

1 reply

Last post Aug 07, 2019 09:54 AM by Chris Becke

  • msdeploy to Sql Server requirements?

    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.

  • Re: msdeploy to Sql Server requirements?

    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
    set @p2=default
    exec sp_dbcmptlevel @dbname=N'conduit ',@new_cmptlevel=@p2 output
    select @p2

    When I attempt to execute this script the error that results is "incorrect syntax near the keyword 'default'."