Can't Export Data-tier Application for Azure

sql azure sql-server-2012 ssms-2012 bacpac
user1477388 picture user1477388 · Mar 13, 2014 · Viewed 20.4k times · Source

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?

Answer

David Atkinson picture David Atkinson · Mar 17, 2014

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.

Related questions

Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different rows into a single row. I'm looking to do this in many different places, so having a function to facilitate this would be nice. I've tried solutions using COALESCE and FOR …

Read More
Error when connect database continuously

When I am querying from database in continuous looping, after some time I get an error : An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using …

Read More
Unexpected EOF encountered in BCP

Trying to import data into Azure. Created a text file in Management Studio 2005. I have tried both a comma and tab delimited text file. BCP IN -c -t, -r\n -U -S -P I get the error {SQL Server Native …

Read More