Search code examples
sqlazuresql-server-2012ssms-2012bacpac

Can't Export Data-tier Application for Azure

I am trying to create a .bacpac file of my SQL 2012 database.

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:

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:

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?

Solution

  • 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.

    This blog post explains how you can use SQL Server Data Tools to modify your database to make it Azure compliant.

    It sounds like you added clustered indices. Based on the message above, it appears you still need to address TextInRowSize and IsMappedToWindowsLogin."

    Ref. http://social.msdn.microsoft.com/Forums/fr-FR/e82ac8ab-3386-4694-9577-b99956217780/aspnetdb-migration-error?forum=ssdsgetstarted

    Edit (2018-08-23): Since the existing answer is from 2014, I figured I'd serve it a fresh update... Microsoft now offers the DMA (Data Migration Assistant) to migrate SQL Server databases to Azure SQL.

    You can learn more and download the free tool here: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sql-server-database