question

Jacob-4626 avatar image
0 Votes"
Jacob-4626 asked ·

The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider is not valid

DACPAC Deployment is failed as it says Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. Target platform is SQL 2019.

azure-sql-database
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Jacob-4626 Are you deploying from your local machine or from a deployment pipeline?
If it is from your local machine or VM, please make sure you have the latest version of SSMS installed.

0 Votes 0 ·
Jacob-4626 avatar image Jacob-4626 KalyanChanumolu-MSFT ·

Thanks for your valuable time.

It is from the deployment pipeline.

0 Votes 0 ·
image.png (33.5 KiB)

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered ·

@Jacob-4626 Thank you for providing additional context.
This is happening because the build agent you are using doesn't have the required version of DacFX.
Please download and install the version appropriate for your build agent from here

Do let us know if you still face any issues.


If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.