Sample Header Ad - 728x90

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