schemachange
schemachange copied to clipboard
How do I make schemachange skip failures during deployment and proceed to the next script?
** 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.