I’m presently making an attempt to deploy a SQL Server 2019 DACPAC to a server in Azure Pipelines. Now I may run the construct earlier once I was concentrating on SQL Server 2016 (Sql130DatabaseSchemaProvider). However I’ve since upgraded the SQL Server to 2019 and wish to make use of the 2019 supplier (Sql150DatabaseSchemaProvider).
So I modified the goal platform to SQL Server 2019 or Azure SQL Database Managed Occasion in Visible Studio. Pushed my adjustments, the construct labored and created the DACPAC. Now in the case of the discharge and it must deploy the DACPAC I’m operating into the next error:
2020-04-24T11:42:53.5854889Z Inside Error. The database platform service with kind Microsoft.Information.Instruments.Schema.Sql.Sql150DatabaseSchemaProvider just isn't legitimate. You need to ensure the service is loaded, or you will need to present the complete kind identify of a legitimate database platform service.
The YAML for the deploy is as follows:
- process: SqlDacpacDeploymentOnMachineGroup@0 displayName: 'Deploy Database' inputs: DacpacFile: '$(System.DefaultWorkingDirectory)/XXX.XXXXX/Database/XXX.XXXXX.Database.dacpac' TargetMethod: connectionString ConnectionString: '$(DBUpgradeConnectionString)'