This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
SqlPackage /Action:Publish /SourceFile:"./xxx.dacpac" \
/TargetDatabaseName:xxx /TargetServerName:xxx.database.windows.net \
/tu:xx /tp:'xxx' /TargetTrustServerCertificate:True
Error message:
Publishing to database 'xxx' on server 'xxxx.database.windows.net'.
Initializing deployment (Start)
Initializing deployment (Failed)
*** 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 Microsoft Azure SQL Database v12.
Time elapsed 0:00:03.82
Docker Image: mcr.microsoft.com/mssql/server:2022-latest. (Linux amd64 )
sqlpackage version 16.1.8980.0
Mac os version: 13.2.1. ( M1 Max)
Hi @woodymoo,
Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Not that I use SqlPackage or Database Projects, but doesn't the error message make it quite clear what is going on? Your project is target for SQL 2022 or Azure Managed Instance, and now you are trying to deploy it on Azure SQL Database. You need to change the target for your project.
The fact that you are running from a Mac should have nothing to do with it.
Thank you for comments.
I solved the issue by use Azure Data Studio for Mac with latest Sql Server Dacpac Extention ( 1/20/2023 version) .
The database schema and all the tables was successfully published.
Thanks,
Thanks, I tested the issue still exist. And I have solved the issue by Azure Data Studio on Mac... My answer is use Azure Data Studio on Mac....