Since we upgraded some of our Azure SQL servers to V12, we can no longer restore bacpac locally using the sqlpackage.exe command line. We also tried using Management Studio, but did not play dice.
Our local machines for developers work:
Microsoft SQL Server 2014 - 12.0.4213.0 (X64) June 9, 2015 12:06:16 Copyright (c) Microsoft Developer Edition (64-bit) on Windows NT 6.3 (Build 9600 :)
Here is the error we are facing:
*** Database import error: failed to import package. SQL72014 error: .Net SqlClient data provider: Msg 33233, level 16, state 1, line 1 You can create a user with a password only in the database. SQL72045 error: Script runtime error ....
It seems that there are problems creating users that have been added by scripts.
Anyone else run into this issue?
Update: Apparently, this has been a problem since April. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/85bb12e8-5ae4-409c-93fa-8a9d025c6b35/error-when-importing-a-datatiers-application-from-azure-db-as- contained? forum = ssdt
Work on the above post works. You need to modify the bacpac file and create a new checksum: http://inworksllc.com/editing-sql-database-azure-bacpac-files/
This is a workaround, not a fix.
Update: it looks like it will be fixed soon.
source share