A project which specifies SQL Server 2012 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12

user_6519111 0
Viewed 4005

When I try to publish my code first project into Azure, it shows me this warning:

Warning : A project which specifies SQL Server 2012 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.

How can I change the target platform?

I've googled it, but what ever I've found was a sql project of data project, etc.

visual-studio-2017 ef-code-first azure entity-framework c#
2 Answers

@David Browne's link leads to the answer, quoting directly from his link:

To change a project’s target platform

Right-click your project in Solution Explorer and select Properties. Click the Project Settings tab on the left to access the Project Settings property page.

The Target platform dropdown list in this page contains all the supported SQL Server platforms that a database project can be published to. For this procedure, select SQL Azure.

Of course for this specific warning, you'll want to select: Microsoft Azure SQL Database V12

user_5509750

I was getting the same problem using SSMS 2012.

The solution was:

  1. Download and install the latest version of SMSS (in my case, 2018).
  2. Restar the pc.
  3. Log in to my localhost server on SMSS.
  4. Select my db and try again to "Deploy db to Ms Azure".

Good luck.

user_94190760
Related