Error importing bacpak in Sql Server 2012

Question

I get this error when importing bacpac file from azure window

TITLE: Microsoft SQL Server Management Studio ------------------------------ Count not load schema model from package. (Microsoft.SqlServer.Dac) ------------------------------ ADDITIONAL INFORMATION: Internal Error. The internal target platform type SqlAzureDatabaseSchemaProvider does not support schema file version '2.5'. 

Most of the online help suggests upgrading SSDT, but I have the latest version of SSDT for VS2012 installed

Answer 1

Update - with a number of new features, including the Query Store, it is now better to use SQL Server Management Studio Preview for import. In some cases, this will be necessary given the updated features in the bacpac file. You can install it from the download page. On this download page, select “Download SQL Server Management Studio Preview” to install.

Original answer The best solution is to install SQL Server Management Studio 2014 on the Express Download page. On this download page, select "MgmtStudio 32BIT \ SQLManagementStudio_x86_ENU.exe" when you click the download link. SSMS 2014 contains a newer version of DacFx, supporting version 2.5, and full support for SQL Server 2005-2014 dbs along with Azure DB.

A few notes in DacFx / SqlPackage:

• Installing the latest SSDT will not fix the problem because SSDT no longer installs the Dac DLL in a shared location. Instead, it installs them in the Visual Studio installation directory (C: \ Program Files (x86) \ Microsoft Visual Studio 12.0 \ Common7 \ IDE \ Extensions \ Microsoft \ SQLDB \ DAC \ 120).

• To upgrade the DacFx binaries used in SSMS to the latest version, you must install DacFramework.msi directly. You can download the latest version for 2014 here (this will update the location used by SSMS 2014), or if you need to use SSMS 2012 the latest compatible version is found here .

• SqlPackage.exe supports bacpacs. You need to use the Import / Export actions for bacpacs, not the Extract / Publish actions used for dacpacs.

Answer 2

It will not be directly restored. When you have already installed SQL Server Data Tools, check the links.

http://social.technet.microsoft.com/Forums/en-US/66a4dfeb-c626-45eb-af3c-00e7e5996203/bacpac-file-import-from-windows-azure-fails?forum=ssdt

Azure SQL Database Bacpac Local Restore

http://social.msdn.microsoft.com/forums/windowsazure/en-us/36035d1e-fda8-4388-99c4-ba2ff7c5a5e1/new-sql-azure-bacpac-format-not-working-with-sql-2012

http://saransh77.wordpress.com/2013/05/02/part-1-how-to-manually-backup-azure-sql-database-and-import-in-on-premise-sql-server/

Answer 3

It seems to me that something has recently changed the side of Azure so that it doesn’t even work with SQL Server 2014 Management Studio. I had to install cumulative update 5 on SQL Server 2014 Management Studio to work again. Cumulative update 6 seems to be disabled, so you can also try this.

Answer 4

I upgraded my SQL Server 2012 from SP2 and then I was able to actually import the BACPAC files from Azure. You can try this.

Answer 5

I understand that this has been a while, but those who have this problem arise from having an earlier version of the Microsoft® SQL Server® Data-Tier Application Framework.

Installing the latest version fixes the problem.

While I was writing this last one, I used an older one that was incompatible with the bacpac file that I was trying to import.

http://www.microsoft.com/en-us/download/details.aspx?id=46898