Disable a single migration from a set of migrations

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:

Answers

  • Kendra_LittleKendra_Little Portland, OR, USA Posts: 46 Silver 3
    Hi Albert,

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

    Kendra
    -------------------------------
    @Kendra_Little
    DevOps Advocate at Redgate
  • AlbertWongAlbertWong Posts: 5 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.
Sign In or Register to comment.