All geek questions in one place

Failed to import / deploy database in SQL Azure: "The specified service target (business / network) is invalid."

I am trying to move my databases to a new Azure subscription. I just simply clicked "Deploy to Azure" in the local database from SSMS and deployed it to the specified Azure server. Import / export of the BACPAC file also works. However, I cannot do anything on the new server. I keep getting the error:

"The specified service target" Web "is invalid."

Google, I found this thread explaining the need to update the CREATE DATABASE template to host Azure databases (Azure update, I assume). However, the fix is provided specifically for SQL Server 2014, and I am using SQL Server 2012. I checked other cumulative updates for 2012 here , but did not find a fix for the problem.

Is there any other way I can fix this without having to upgrade to 2014?

Just to summarize my software versions:

  • SQL Server 2012
  • SQL Management Studio 11.0.2100.60
  • Local database: SQL Server 10.50.16000
  • Old Azure Server: SQL Server 11.0.9230
  • New Azure Server: SQL Server 13.0.15
+4
3

, V12 - -. SSMS 2014, V11 . , Web Business edition . , .

+6

Visual Studio,
SQL Azure,
.
.

I tried the above and did not work for me - this solution worked!

0
source

Source: https://habr.com/ru/post/1585099/

More articles:


All Articles