How can we help you today? How can we help you today?

is skipExecutingMigrations available on Community Edition

Is skipExecutingMigrations available on Community Edition?

I have read docs and watched Redgates YouTube videos on these feature but do not see comments regarding support for this feature on the various editions.

Empirically, I do not see skipExecutingMigrations working on10.9.1 Community Edition.

When I look in the code, I do not see the configuration being used.  Instead, I see a local variable being set.  See
org.flywaydb.core.internal.command.DbMigrate.migrateGroup(boolean)

On StackExchange, a comment indicates that it is a Teams feature, not a Community but I would like to get conformation from an authoritative source.
https://stackoverflow.com/questions/29012034/how-to-skip-a-specific-migration-with-flyway

The docs list cherryPick as being available on Teams not Community
https://documentation.red-gate.com/flyway/flyway-cli-and-api/configuration/parameters/flyway/cherry-pick

The docs for skip executions do not indicate that it is Teams or Enterprise only
https://documentation.red-gate.com/flyway/flyway-cli-and-api/configuration/parameters/flyway/skip-executing-migrations

The  glossary does not explicitly list skip executions
https://documentation.red-gate.com/fd/feature-glossary-165740620.html

Is skipExecutingMigrations available on Community Edition?
kenshine
0

Comments

9 comments

Sort by
  • ATurner
    Hi kenshine

    Where are you pulling your community artifact from?
    ATurner
    0
  • kenshine
    The artifact is stored in my teams artifactory.  Ot Spring deployable is built with Gradle:

     api group: 'org.flywaydb', name: 'flyway-core', version: '10.9.1'

    Let me explain what I needed to do.  I have some deployment thats have migrations applied, lets say up to 107.  There are 110 migrations.   For deployment at 107, I want to apply 108, 109 and 110. For other deployments are at the last release, migration 100.  For that deployment, I do not want apply 101 thru 110.  Instead, I want to skip those and apply a single file that contains all the SQL that was in migrations 101 thru 110.

    This is similar to your baseline feature, but instead of deploying to a new env and having all SQL in 1 file, I want 1 file with all the SQL from last official release.

    Thanks much for your help.

    kenshine
    0
  • kenshine
    Also, is skipExecutingMigrations available on Community Edition?
    kenshine
    0
  • ATurner
    Hi kenshine

    Apologies, I may have worded my question poorly there. 
    What maven repository is it you are getting flyway from? Is it the redgate one? https://download.red-gate.com/maven/release/com/redgate/flyway/
    ATurner
    0
  • kenshine
    I am getting it as part of my team's build process.  I am not sure how it entered the pipe line.  I can attach the pom, if that helps.

    kenshine
    0
  • kenshine
    Did the pom answer your question of " Is it the redgate one?"  
    Is it Redgate Community, as I think?  
    I now see there is an Open-Source Software (OSS) version.  From the pom. I can't tell which one it is.  Can you?
    kenshine
    0
  • kenshine
    I was just informed that my organization got it from https://mvnrepository.com/artifact/org.flywaydb/flyway-core
    Is that the OSS version?  Thanks.
    kenshine
    0
  • ATurner
    Hi kenshine

    To get this working, you'll need to get the flyway-core dependency from the Redgate repository as described here: https://documentation.red-gate.com/fd/api-java-184127629.html
    ATurner
    0
  • Adam_Britt
    kenshine We have plans to opensouce skipExecutingMigrations so it will be in the Mavern repository in the future. Are you able to use the Redgate repository in the mean time?
    Adam_Britt
    0

Add comment

Please sign in to leave a comment.