SQLPackage : Import or Export SQL Azure BACPAC without users
8
votes
1
answer
5367
views
I know how to use
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
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

Asked by Peter PitLock
(1405 rep)
Apr 18, 2017, 02:00 PM
Last activity: May 14, 2025, 02:02 PM
Last activity: May 14, 2025, 02:02 PM