I have a database, let's call XYZ on my local SQL Server Developer 2019 edition. I wanted to deploy it to the Azure SQL Database. I used the wizard "Deploy Database to Microsoft Azure SQL Database" on SSMS and it worked. And then I made some changes in my local database and used the wizard "Extract data-tier application" on SSMS to generate the XYZ.dacpac file. I tried to use the following command SqlPackage.exe to deploy the DACPAC to my Azure SQL Database:
SqlPackage.exe /SourceFile:"DIRECTORY_PATH\XYZ.dacpac" /Action:Publish /TargetServerName:"azure_sql_server_name" /TargetDatabaseName:"XYZ" /TargetUser:"sql_admin_user" /TargetPassword:"sql_admin_user_passwrord"
but I got the error:
An error occurred during deployment plan generation. Deployment cannot continue.
A project which specifies SQL Server 2019 or Azure SQL Database Managed Instance as the target platform cannot be published to Microsoft Azure SQL Database v12.
Anyone knows how to fix it? Thanks in advance!