无法导入SQL Azure的V12 BACPAC：＆QUOT;类型Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider无效＆QUOT; [英] Unable to import SQL Azure V12 BACPAC: "type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid"

问题描述

我试图从SQL Azure的（V12）数据库导入导出BACPAC到本地SQL Server 2012实例，但我不断收到以下错误。我试图安装DAC和<链接SSDT更新href=\"http://blogs.msdn.com/b/ssdt/archive/2014/12/18/sql-server-database-tooling-$p$pview-release-for-the-latest-azure-sql-database-update-v12-$p$pview.aspx\">this博客文章，但它没有帮助。

我该如何解决这个问题？

 标题：微软SQL Server Management Studio中
------------------------------数量而不是从包中加载的架构模式。 （Microsoft.SqlServer.Dac）------------------------------
附加信息：内部错误。与类型Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider数据库平台服务是无效的。您必须确保该服务被加载，否则你必须提供一个有效的数据库平台服务的全类型名称。 （Microsoft.Data.Tools.Schema.Sql）------------------------------
纽扣：好
------------------------------
 

解决方案

更新：新的 SQL Server Management Studio中preVIEW 是导入到SQL Azure的数据库的最佳途径。它有所有最新的Azure SQL数据库的特点和验证支持。另外它有一个独立的Web安装程序，每个月都会自动更新为新的功能变得可用。下面提安装CU更新的难度给出意见，这将是一个简单的与放大器;更快的解决问题的办法。

原来的答复：
如果您使用的是SQL Server Management Studio中进行导入，您必须安装SSMS 2014年CU5或CU6。上安装CU6信息可<一个href=\"http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/02/17/cumulative-update-6-for-sql-server-2014-rtm.aspx\">here.在你的问题中显示的错误表明您正在使用SSMS的旧版本。

**更新：**
根据下文马丁的回答，我想澄清两件事情。

1. SSMS用于SQL Server 2014 SSMS的全面支持新的Azure SQL数据库V12的特点，针对这一目标特别是导入/导出的唯一版本。这是因为V12拥有（几乎）与SQL Server的功能特性，2014年和较旧版本的工具不具备这种支持。需要注意的是SSMS 2014年是完全与SQL Server 2005及以上向后兼容。




2. 有是造成与升级Azure的SQL数据库V12数据库的问题一个单独的，暂时性的问题。这已得到解决和正确的地方找到有关解决此信息是的<段C3 href=\"http://azure.microsoft.com/en-us/documentation/articles/sql-database-$p$pview-plan-$p$ppare-upgrade/#limitations\">Plan和prepare升级页面。总之，如果你已经导出未能成功地导入BACPAC因为这个问题可以从的此处修复SSMS这个问题。

披露：我在SQL Server工具团队合作

。

I am trying to import the exported BACPAC from an SQL Azure (v12) database into a local SQL Server 2012 instance, but I keep getting the error below. I have tried installing the DAC and SSDT updates linked from this blog post, but it's not helping.

How can I fix this?

TITLE: Microsoft SQL Server Management Studio
------------------------------

Count not load schema model from package. (Microsoft.SqlServer.Dac)

------------------------------
ADDITIONAL INFORMATION:

Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. (Microsoft.Data.Tools.Schema.Sql)

------------------------------
BUTTONS:

OK
------------------------------

解决方案

Updated: The new SQL Server Management Studio Preview is the best way to Import to Azure SQL DB. It has support for all the latest Azure SQL DB features and validations. In addition it has a standalone web installer that is automatically updated each month as new features become available. Given comments below mentioning the difficulty of installing a CU update, this would be a simpler & quicker solution to the problem.

Original Answer: If you are using SQL Server Management Studio to perform the Import, you must have SSMS 2014 CU5 or CU6 installed. Information on installing CU6 is available here. The error shown in your question indicates you're using an older version of SSMS.

**Update: ** In response to Martin's answer below, I'd like to clarify 2 things.

1. SSMS for SQL Server 2014 is the only version of SSMS with full support of the new Azure SQL DB v12 features, notably Import/Export against this target. This is because v12 has (almost) feature parity with SQL Server 2014 and older versions of the tooling do not have support for this. Note that SSMS 2014 is fully backwards compatible with SQL Server 2005 and up.

2. There was a separate, temporary issue that caused problems with databases upgraded Azure SQL DB v12. This has been resolved and the correct place to find information about solving this are in section C3 of the Plan and Prepare to Upgrade page. In summary if you've exported a bacpac that is failing to import due to this issue you can download the latest DacFramework.msi from here to fix this issue in SSMS.

Full disclosure: I work on the SQL Server tools team.

这篇关于无法导入SQL Azure的V12 BACPAC：＆QUOT;类型Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider无效＆QUOT;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！