Disable a single migration from a set of migrations

AlbertWongAlbertWong Posts: 7 New member
in SQL Change Automation
Hello,

I'm using SQL Change Automation to handle our database deployments. During development, I've created a number of database migrations. How do I disable one migration so it isn't considered when deploying to a database. Basically, I'm offloading the running of the particular migration to a DBA since the DBA needs to do some manual work on the database to support the deployment anyway.  Can I delete the particular lines from the DeploymentOrder.json file?



Tagged:
· Share on Twitter

Answers

  • Kendra_LittleKendra_Little Posts: 139 Gold 3
    Hi Albert,

    To clarify, is your requirement to prevent that single migration from deploying *after* having created the Release Artifact?

    Kendra
    · Share on Twitter
  • AlbertWongAlbertWong Posts: 7 New member
    No, I would like to disable the single migration prior to creating new release artifacts. I tried removing the migration reference from DeploymentOrder.json, but SQL Change Automation displays an error that it expects the migration but it can't find it.
    · Share on Twitter
Sign In or Register to comment.