I tried method given in this answer by Ramankant Dadhichi but deploying failed.
Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server
I have my database in managed instance. and i extracted dacpac using SSTD but now when i try to deploy extracted file using SSMS. I am getting following error:
Could not deploy package.
Error SQL0: The element [releaseengineer] cannot be deployed. This element contains state that cannot be recreated in the target database.
Error SQL0: The element [Reporter] cannot be deployed. This element contains state that cannot be recreated in the target database.
(Microsoft.SqlServer.Dac)
Best Answer
Have a look at the commentary here. Has the login been created on each instance using the same SID? If not then this might be the cause of the issue.