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
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.
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