0

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)

  • In your database, what object types are "realeaseengineer" and "Reporter"? – Martin Cairney Feb 10 at 1:57
  • they are users, owner of some schemas – Priya Sharma Feb 10 at 2:22
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.

| improve this answer | |
  • I have deleted those users and that error got solved but now its showing error that certificate and symmetric key are not supported in Ms azure sql database v12. – Priya Sharma Feb 10 at 4:09
  • Because we don't have access to the file system in Azure SQL Database, certificates and keys need to be handled differently. This link discusses some of the differences. I think you might need to drop these and re-add them after deployment. – Martin Cairney Feb 10 at 22:34
  • Thank you. i will go through them and come back if any doubts. – Priya Sharma Feb 11 at 0:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.