Flyway - Cant run Multiple sql Scripts

Question

My files - V3.2-alter.sql and V3.2-3insert_fmcc.sql

If i am running flyway - i get error ..

[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:3.2.1:migrate (default) on project SnapdealOPS: org.flywaydb.core.api.FlywayException: Found more than one migration with version 3.2 Offenders:

[ERROR] -> /home/kartikeya/git/SnapdealOPS/MySQLDB/release-V3.2/V3.2-1alter.sql (SQL) [ERROR] -> /home/kartikeya/git/SnapdealOPS/MySQLDB/release-

V3.2/V3.2-3insert_fmcc.sql (SQL)

Cant i run multiple sql scripts for single version . Do i have to put all the queries in single file .

Thilo · Accepted Answer · 2016-01-21 08:57:52Z

4

If you want two files, you need to give them two versions (like 3.2.0.0.1 and 3.2.0.0.2). That is how the order of application is defined.

answered Jan 21, 2016 at 8:57

Thilo

264k107 gold badges527 silver badges674 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kaka Over a year ago

But they all belong to our single release (version) 3.2 ... i mean logically it wouldnt make sense to have different versions based on file not on version

Thilo Over a year ago

You need some mechanism to define the order of application. Flyway provides: order of lines within the file and numeric ordering of version numbers between files.

Collectives™ on Stack Overflow

Flyway - Cant run Multiple sql Scripts

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related