I am trying to create a .bacpac file of my SQL 2012 database.
我正在尝试创建SQL 2012数据库的.bacpac文件。
In SSMS 2012 I right click my database, go to Tasks, and select Export Data-tier Application. Then I click Next, and it gives me this error:
在SSMS 2012中，我右键单击我的数据库，转到“任务”，然后选择“导出数据层应用程序”。然后我单击Next，它给了我这个错误：
Error SQL71564: Element Login: [myusername] has an unsupported property IsMappedToWindowsLogin set and is not supported when used as part of a data package.
(Microsoft.SqlServer.Dac)
I am trying to follow this tutorial so that I can put my database on Azure's cloud:
我正在尝试遵循本教程，以便将数据库放在Azure的云上：
http://blogs.msdn.com/b/brunoterkaly/archive/2013/09/26/how-to-export-an-on-premises-sql-server-database-to-windows-azure-storage.aspx
How can I export a .bacpac file of my database?
如何导出数据库的.bacpac文件？
2 个解决方案
#1
5
I found this post referenced below which seems to answer my question. I wonder if the is a way to do this without having to delete my user from my local database...
我发现下面引用的这篇文章似乎回答了我的问题。我想知道这是否是一种方法，而无需从我的本地数据库中删除我的用户...
"... there are some features in on premise SQL Server which are not supported in SQL Azure. You will need to modify your database before extracting. This article and several others list some of the unsupported features.
“... SQL Server中有一些SQL Server不支持的功能。在解压缩之前，您需要修改数据库。本文和其他几篇文章列出了一些不支持的功能。
This blog post explains how you can use SQL Server Data Tools to modify your database to make it Azure compliant.
此博客文章介绍了如何使用SQL Server数据工具修改数据库以使其符合Azure。
It sounds like you added clustered indices. Based on the message above, it appears you still need to address TextInRowSize and IsMappedToWindowsLogin."
听起来你添加了聚集索引。根据上面的消息，您似乎仍然需要解决TextInRowSize和IsMappedToWindowsLogin。“
参考。 http://social.msdn.microsoft.com/Forums/fr-FR/e82ac8ab-3386-4694-9577-b99956217780/aspnetdb-migration-error?forum=ssdsgetstarted
#2
5
SQL Azure doesn't support windows authentication so I guess you'll need to make sure your database users are mapped to SQL Server Authentication logins instead.
SQL Azure不支持Windows身份验证，因此我猜您需要确保将数据库用户映射到SQL Server身份验证登录。
#1
5
I found this post referenced below which seems to answer my question. I wonder if the is a way to do this without having to delete my user from my local database...
我发现下面引用的这篇文章似乎回答了我的问题。我想知道这是否是一种方法，而无需从我的本地数据库中删除我的用户...
"... there are some features in on premise SQL Server which are not supported in SQL Azure. You will need to modify your database before extracting. This article and several others list some of the unsupported features.
“... SQL Server中有一些SQL Server不支持的功能。在解压缩之前，您需要修改数据库。本文和其他几篇文章列出了一些不支持的功能。
This blog post explains how you can use SQL Server Data Tools to modify your database to make it Azure compliant.
此博客文章介绍了如何使用SQL Server数据工具修改数据库以使其符合Azure。
It sounds like you added clustered indices. Based on the message above, it appears you still need to address TextInRowSize and IsMappedToWindowsLogin."
听起来你添加了聚集索引。根据上面的消息，您似乎仍然需要解决TextInRowSize和IsMappedToWindowsLogin。“
参考。 http://social.msdn.microsoft.com/Forums/fr-FR/e82ac8ab-3386-4694-9577-b99956217780/aspnetdb-migration-error?forum=ssdsgetstarted
#2
5
SQL Azure doesn't support windows authentication so I guess you'll need to make sure your database users are mapped to SQL Server Authentication logins instead.
SQL Azure不支持Windows身份验证，因此我猜您需要确保将数据库用户映射到SQL Server身份验证登录。