Sample Header Ad - 728x90

SQLPackage : Import or Export SQL Azure BACPAC without users

8 votes
1 answer
5367 views
I know how to use SQLpackage.exe. I can export from SQL Azure and create a bacpac. I can also Import to SQL Server via SQLPackage.exe. I want to export or import without the users in the database. The users are preventing the normal import to fail. > Error importing database :could not import package. > > Error SQL72014 Cannot grant, deny or remove permissions to or from special roles enter image description here I can't delete the users before I export, or exclude them from the import. Currently we have to backup the database, restore it on SQLAzure, delete the use on this second database, then create a bacpac from the restored database. How do I get around this? can I use IgnoreUserSettingsObjects with my sqlpackage ? I tried using the parameters but it fails
Asked by Peter PitLock (1405 rep)
Apr 18, 2017, 02:00 PM
Last activity: May 14, 2025, 02:02 PM