Client Pay Portal
 sql azure

Error Restoring SQL Azure DB to SQL Server 2012

Today I attempted to restore a SQL Azure bacpac file to my local SQL Server 2012 instance and got cold-cocked by a big, ‘ol error message:

“ Internal Error. The internal target platform type SqlAzureDatabaseSchemaProvider does not support schema file version '2.5'. (File: [BACPAC FILE NAME]) (Microsoft.Data.Tools.Schema.Sql)”

Looks like the SQL Server Data Tools team pushed out an update in December for the tools. A simple install fixed me up and I was able to restore my DB without errors.

The update contains a number of enhancements to several parts of the tool:Database Unit Testing
Integration with SSDT Power Tools
Updated Data-Tier Application Framework (This is the part that makes Azure restores work again!)
Bug Fixes

The SSDT update can be downloaded here:

SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015 
SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014 

Author

Wiz E. Wig, Mascot & Director of Magic
Wiz E. Wig

Director of Magic