In current Flyway (at least as of now, version 10) for that Mixed migration mode should be use with executeInTransaction=false value in the script configuration file. See more for details: