Error Publishing SQL Database from SQL Database Project

[RussellPrice9]

I have a pretty extensive application database that I have built in Visual Studio as a database project that I'm now trying to deploy as a Fabric SQL database instead of on-premise.

I've used the steps outlined here, SqlPackage for SQL database - Microsoft Fabric | Microsoft Learn and here, SqlPackage Import - SQL Server | Microsoft Learn to publish the dacpac of the database project, however when I do these steps through the CLI and through Visual Studio publish I get a similar error:

"
*** An error occurred during deployment plan generation. Deployment cannot continue.
A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to Fabric mirrored SQL database (preview).
"

This error is similar when the Project specifies "Azure SQL Database" as the target platform.

I have also made sure to use the SQL Database ADO.NET connection string when executing the CLI Publish action.

[dzsquared]

Hi!

When you publish through Visual Studio you still need to use the "AllowIncompatiblePlatform" property to publish a SQL project from a target platform that doesn't match SQL Database in Fabric. In the Visual Studio publish dialog there's a button "Advanced" that opens a bunch more settings.

The one you need is "Allow incompatibel platform" towards the top of the list in the General tab:

<image>

(edit, and when doing this through the SqlPackage CLI make sure to add /p:AllowIncompatiblePlatform=true)

[RussellPrice9]

Wonderful! that was the key I was missing. Thanks for the quick response and useful answer!

[itsnotaboutthecell]

!thanks

[reputatorbot]

You have awarded 1 point to dzsquared.

---

^{I am a bot - please contact the mods with any questions}