How I can rollback dacpac deployment for synapse Serverless SQL Objects via Azure DevOps ?

Question

How I can rollback dacpac deployment for synapse Serverless SQL Objects via Azure DevOps ?

Siddharth Joshi 231

Hi, I want to rollback my dacpac deployment, I'm promoting my serverless SQL objects to the upper environment via Azure DevOps CI/CD but due to some issue my deployment is failing (publish) I noticed that dacpac has done partial deployment so I believe this is not a correct behavior either it should deploy all artifacts or none, but as it is doing partial deployment I want to rollback it.

Siddharth Joshi 231 Reputation points

2023-04-05T09:41:02.74+00:00

Hi @Bhargava-MSFT I'm talking about the dacpac deployment for serverless sql objects (Synapse Analytics )like external tables, external resources, views etc . I'm promoting these artifacts from one serverless pool to another via dacpac way but suppose if my deployment fails to deploy view but as in my dacpac file there are other objects as well like external tables so by default its deploy external tables and then its failed while deploying view so I don't want this kind of behavior either it should deploy all artifacts or none. So if my understanding is correct if i rollback with previous release it will update the schema and objects but how i can delete objects which is partially deployed ?
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-08T00:36:31.28+00:00

Hello Siddharth Joshi , I am checking to see if you got a chance to look into my earlier response. Please let me know if you have any further questions.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-10T23:40:04.5033333+00:00

Hello Siddharth Joshi , I am checking to see if you got a chance to look into my earlier response.
Siddharth Joshi 231 Reputation points

2023-04-11T08:05:41.7+00:00

@Bhargava-MSFT Let me check it. Thanks for your response.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-11T16:54:54.32+00:00

Thank you, Siddharth Joshi

1 answer

Your answer

Siddharth Joshi 231 Reputation points

2023-04-05T09:41:02.74+00:00

Hi @Bhargava-MSFT I'm talking about the dacpac deployment for serverless sql objects (Synapse Analytics )like external tables, external resources, views etc . I'm promoting these artifacts from one serverless pool to another via dacpac way but suppose if my deployment fails to deploy view but as in my dacpac file there are other objects as well like external tables so by default its deploy external tables and then its failed while deploying view so I don't want this kind of behavior either it should deploy all artifacts or none. So if my understanding is correct if i rollback with previous release it will update the schema and objects but how i can delete objects which is partially deployed ?
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-08T00:36:31.28+00:00

Hello Siddharth Joshi , I am checking to see if you got a chance to look into my earlier response. Please let me know if you have any further questions.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-10T23:40:04.5033333+00:00

Hello Siddharth Joshi , I am checking to see if you got a chance to look into my earlier response.
Siddharth Joshi 231 Reputation points

2023-04-11T08:05:41.7+00:00

@Bhargava-MSFT Let me check it. Thanks for your response.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-11T16:54:54.32+00:00

Thank you, Siddharth Joshi

Answer 1

Bhargava-MSFT 31,261 Microsoft Employee Moderator

Hello Siddharth Joshi , Please correct me if my understanding is wrong. Your release pipeline is partially deployed with the objects, and you want to rollback the changes to the previous good release. To roll back to a previous state, you can access the Release Management for the project, identify the previous release, and redeploy it to replace the newer release. If you look at the below screenshot, my release pipeline-13 failed, and I was able to roll back the changes using my previous release pipeline-11 User's image

User's image

Set the DropObjectsNotInSource=True to drop the objects that exist in the target but not source should be dropped; I hope this helps. Please let me know if you have any further questions.

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-06T18:45:49.83+00:00

Hello Siddharth Joshi , In your case, you need to set the DropObjectsNotInSource=True. The default option is 'False' meaning, deployment doesn't drop the objects in the target but not in the project. True: if objects that exist in the target but not source should be dropped; otherwise false. Default is false. https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dac.dacdeployoptions.dropobjectsnotinsource?view=sql-dacfx-150 A similar thread has been discussed here. https://stackoverflow.com/questions/28344010/ssdt-how-to-deploy-dacpac-without-losing-custom-client-database-objects#:%7E:text=Just%20use%20parameter%20%22Drop%20objects,when%20publishing%20from%20within%20VS Please let me know if you have any further questions.

Share via

How I can rollback dacpac deployment for synapse Serverless SQL Objects via Azure DevOps ?

1 answer

Your answer