CODEWITHSUNDEEP
sqldatabasescriptingflyway
Adesina Anuoluwapo
Adesina Anuoluwapo

Reputation: 3

How can i specify that a particular flyway migration script be run on a different database

I have some migration scripts in my db.migration folder that run on my default database server. I want to add a new migration script but i want it to be run on an entirely different server, without affecting the previous migration scripts.

Upvotes: 0

Views: 795

Answers (1)

Julia Hayward
Julia Hayward

Reputation: 2155

You essentially need two separate configurations:

  • put migration scripts for server A in a folder and specify that folder as a location in A.conf, which also has the JDBC connection url for server A
  • do the same for server B in a separate folder and specify it in B.conf
  • then flyway migrate -configFiles=A.conf.

This is fine even if you want the migration version numbers to run in one contiguous sequence.

Upvotes: 2

Related Questions