2

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 Azure SQL Managed Instance. I extracted a dacpac using SSDT. But, now when I try to deploy the extracted file using SSMS, I get the 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)

Solomon Rutzky
  • 70,048
  • 8
  • 160
  • 306

1 Answers1

0

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.

Martin Cairney
  • 433
  • 2
  • 9