Deployment cannot continue

Question

In Microsoft Visual Community 2022, Version 17.9.0, from SQL Server Object Explorer, I connected successfully to the online SQL Server using the following connection string: "Data Source=i6hyqlspvc.database.windows.net,1433;User ID=Noor1;Password=********;Connect Timeout=30;Encrypt=True;Trust Server Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False" Under the server name in the SQL Server Object Explorer, I see "Databases" leaf. After R-Click on Databases , I chose "Publish Data-Tier application" which shows a dialog-box. I provided a valid local .dacpac, target database connection, Databasename, and Publish Script name. Then, I clicked on "Publish" Button. The publishing process starts and go through the "Creating Publishing preview" process successfully then it show the following error" Publishing Data-tier Application

Creating Publish preview Publish failed. An error occurred during deployment plan generation. Deployment cannot continue. A project which specifies SQL server 2019 target platform cannot be published to Microsoft Azure SQL database v12 How can I solve this problem and publish the locally created database to the server?

Answer 1

Hi
Noorann Tech,

Welcome to Microsoft Q&A forum.

As I understand, your deployment is failing with an error occurred during deployment plan generation. Deployment cannot continue. A project which specifies SQL server 2019 target platform cannot be published to Microsoft Azure SQL database v12.

Could you please share more details about the Database and screenshots of the errored step?

Also, please refer to similar posts which could be helpful:

https://stackoverflow.com/questions/40628071/database-deployment-an-error-occurred-during-deployment-plan-generation-deplo

https://stackoverflow.com/questions/59688412/not-able-to-build-visual-studio-database-project-targeting-azure-sql-database-wh

A DAC can be deployed to SQL Database, or an instance of the Database Engine running SQL Server 2005 (9.x) Service Pack 4 (SP4) or later. If you create a DAC using a later version, the DAC may contain objects not supported by SQL Server 2005 (9.x). You can't deploy those DACs to instances of SQL Server 2005 (9.x).

Awaiting your reply. Thanks