schemachange icon indicating copy to clipboard operation
schemachange copied to clipboard

How do I make schemachange skip failures during deployment and proceed to the next script?

Open zroytman opened this issue 1 year ago • 6 comments

** What are you trying to accomplish? ** I'm using SchemaChange as part of Azure DevOps Pipeline where i'm trying to deploy several sql scripts. In most of my cases the scripts have no dependencies between each other, but SchemaChange stops deployment on the first failure and doesn't proceed with the other scripts. Is there any option/flag/configuration that can provide me such a behavior?

Example: 3 scripts changed and are being deployed by schemachange. script 1 successfully deployed - schemachange tries the next one (2). script 2 failed on some sql error - i expect from schemachange to move to the next script (3) but it stops here.

** What options have you tried so far ? ** Tried to find some flag or option of configuration in SchemaChange - nothing found.

zroytman avatar Feb 20 '24 13:02 zroytman