flyway-db database specific migration using java class

Question

We are having some upgrade migration that needs to be executed via a java class, some of the alter commands are database specific and we need to support both MSSQL and Oracle. Can we have database type specific java upgrade classes being loaded and executed?

Axel Fontaine · Accepted Answer · 2015-02-23 19:19:47Z

1

You have two options:

Write your Java code so it behaves differently based on the database detected through the connection metadata
Configure Flyway to use different locations based on the current environment

answered Feb 23, 2015 at 19:19

Axel Fontaine

35.4k19 gold badges110 silver badges144 bronze badges

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

2 Comments

SudhirR Over a year ago

Thanks for your response. Please point me to how to do option 2.

Axel Fontaine Over a year ago

The FAQ has the answer: flywaydb.org/documentation/faq.html#db-specific-sql

Collectives™ on Stack Overflow

flyway-db database specific migration using java class

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