c# - FlyWay with interdependent databases -

i've seen posts flyway handling multiple databases seems databases independent. understand it, flyway can handle 1 database per instance creating/cleaning database schemas independent.

multiple datasources migrations using flyway in spring boot application

our problem stems bad db design , won't changed quickly. background, c# old school application mssql db , we're using flyway command line evaluation purposes.

the db(s) set this.

• appdb
• applogdb
• appauditdb
• apparchivedb
• ...

i have examples appdb has views/procedures/etc reference other tables. there cases other dbs access appdb (ie archivedb stored procedures pull appdb).

with dependency between different databases, there anyway flyway can handle migration/clean in order required? example

if have order of scripts

• appdb
  1. v1__create_table
  2. v2__create_proc_pointing_to_archivedb
• archivedb
  1. v1__create_table
  2. v2__create_proc_pointing_to_appdb

how re-done handle more this

• appdb, archivedb
  1. v1__appdb_create_table
  2. v2__archivedb_create_table
  3. v3__appdb_create_proc_pointing_to_archivedb
  4. v4__archivedb_create_proc_pointing_to_appdb