Azure SQL database creation issue from dacpac

2
votes

I am trying to create new SQL Azure database using dacpac file created from local SQL server database using SSDT .

Export Database as dacpac

I am getting error as

Publish failed.An error occured during deployment plan generation. Deployment cannot continue. A project which specifies SQL Server 2017 as the target platform cannot be published to Microsoft Azure SQL Database v12.

But did not get any option to choose while doing Extract Data-tier Application to generate dacpac.

Below is error while creating Azure SQL database :

Publish Data-Tier Application Failed

1
sql-serverazureazure-sql-databasesql-server-data-toolsdacpac

1 Answers

1
votes

You can do this workaround, you can go into the json file for the project and manually target V12. Edit the sqlproj file.

<DSP>Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider</DSP>