"web" is not a valid database version in this release of SQL Server

Yeah! - This is probably true. This weekend I decided to create a DNN website on Azure ... The version for web and business versions is outdated / resigned. In fact, yesterday it was on Lazur.

There are ONLY 2 options in SQL Server 2012 SSMS, however, importing a data-tier application is just web and business. Basic, Standard, and Premium are not disclosed in SSMS 2012.

So ... instead of just asking this question, I will ask another question. Is there an update for SSMS 2012? I ask, since the portable database is 2012, so using SSMS 2014 may not work if the option is to download this version of SSMS and use it.

Other than that ... here's what has already been posted:

Note. SQL Server Database Migration - 2012 DNN version - 02/07/01 (367).

I follow the instructions on this blog post to migrate the DNN website to Azure: http://www.dnnsoftware.com/community-blog/cid/154975/moving-a-dnn-install-to-microsoft-azure-websites . The error I am getting is:

'web' is not a valid database version in this release of SQL Server.

I have 2 options in the import process of "Web" and "Business", they tried both, and none of them will work. There are a few more questions about stack overflows, but they either don't answer or the answers don't work.

I understand that this is vague, but simple enough: it does not work. :) The blog follows the letter. The .bacpac file is created without errors. Importing a data-tier stage simply results in an error caused by the failure to create the target database on Azure for the above reason.

I have an Azure support ticket for this.

It should be simple, something was missing - the missing configuration step when configuring Azure. This may be a free trial, it doesn’t apply to it, and I need to pay something. It's great ... you just need to know what it is.

Who faced this and, in fact, actually solved it?

+5
source share
3 answers

My recommendation is to always use the latest version of SSMS to have the latest updates that support new Azure features, such as full-text search support for Azure SQL Server v12, edit the top 200 lines, desktop, long, etc.

Note that the latest version of SSMS supports SQL Server 2016 through SQL Server 2005, so it will work with your SQL Server 2012 database. The following item was added to the SSMS view for June 2015:

  • Support for the Import / Export Wizard for new service levels of Azure SQL Database (Basic, Standard, Premium).

You can read more at https://msdn.microsoft.com/en-US/library/mt238290.aspx

+1
source

https://support.microsoft.com/en-us/kb/3031047

In future. This fix should work on this issue.

+1
source

This is because the valid database version can be basic or standard or premium . SSMS does not allow you to select it, so the solution is to download the latest version of SSMS.

0
source

All Articles