Backup from dacpac file extracted using SSDT
2
votes
1
answer
1355
views
I tried method given in this answer by Ramankant Dadhichi but deploying failed:
https://dba.stackexchange.com/questions/244167/backup-a-database-from-azure-sql-managed-instance-and-restore-to-on-premise-sql?newreg=ec931412355c4730acfff21d2c7c78cd
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)
Asked by Priya Sharma
(21 rep)
Feb 10, 2020, 01:52 AM
Last activity: Aug 2, 2025, 01:04 PM
Last activity: Aug 2, 2025, 01:04 PM