8

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

Community
  • 1
Peter PitLock
  • 1,405
  • 4
  • 24
  • 32

1 Answers1

0

I was having a similar problem, but I coudn't find a way to generate the .bacpac without users, there is a workarround if you need the copy in the same suscription, the Microsoft Suport Team guide us is doing a COPY directly from the Azure Portal and it worked for me.

Mara del Carmen Bobadilla Vega
  • 1
  • 1