How do I restore Azure bacpac to AWS RDS Instance?

Question

I am trying to restore a .bacpac file from Azure to AWS RDS instance using Import Data-tier Application in SSMS, and I get the error message shown below. The database does not exist in the target.

TITLE: Microsoft SQL Server Management Studio

---

Could not import package.

Warning SQL0: The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins.

Warning SQL72012: The object [DATABASENAME] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.

Warning SQL72012: The object [DATABASENAME_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.

Error SQL72014: .Net SqlClient Data Provider: Msg 50000, Level 20, State 1, Procedure rds_deny_backups_trigger, Line 34 You cannot GRANT/REVOKE 'BACKUP DATABASE' or 'BACKUP LOG' permission for a user.

Error SQL72045: Script execution error. The executed script:

REVOKE BACKUP DATABASE TO [username] CASCADE;

Error SQL72014: .Net SqlClient Data Provider: Msg 2745, Level 16, State 2, Procedure rds_deny_backups_trigger, Line 34 Process ID 61 has raised user error 50000, severity 20. SQL Server is terminating this process.

Error SQL72045: Script execution error. The executed script:

REVOKE BACKUP DATABASE TO [username] CASCADE;

(Microsoft.SqlServer.Dac)

---

BUTTONS:

OK

Answer 1

Please follow the steps provided on this Amazon documentation. AWS recommends migrating using bacpacs with databases with a size 200 GB or less. Note that bacpacs are not transactionally consistent.