Cannot deploy package for SqlServer 2025 using SqlDatabaseProjects #847
Description
Describe the bug
When deploying a MSBuild .sqlproj with SQL Server 2025 latest image I get the following error
Failed to publish database project. Microsoft.SqlServer.Dac.DacServicesException: Could not deploy pacakge. ---> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Internal Error The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql170DatabaseSchemaProvider 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. --->
The .sqlpoj is using Sdk Version 2.0.0-preview.4 and DSP is set to Sql170DatabaseSchemaProvider.
I believe this could be resolved by updating the Microsoft.SqlServer.DacFx package from version 162.5.57 to 170.1.61.
Regression
No response
Steps to reproduce
Create an msbuild sqlproj project
that is using Sdk Version 2.0.0-preview.4 and DSP is set to Sql170DatabaseSchemaProvider.
Expected behavior
This should work once the DacFx library is updated.
Screenshots
No response
IDE and version
VS 2022
IDE version
No response
Nuget packages
CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects version 9.7.2
Additional context
No response
Help us help you
Yes, I'd like to be assigned to work on this item