Flyway数据库迁移到多个模式

I've set up a migration script for my multi-tenant application. the problem was. it's only generating the scripts for the first tenant/schema I've specified on the parameter. Here's my sql script

我为我的多租户应用程序设置了一个迁移脚本。问题是。它只为我在参数上指定的第一个租户/架构生成脚本。这是我的sql脚本

drop table if exists ADMIN_ACCOUNT cascade;

drop table if exists PERSON_NAME cascade;

drop table if exists USER_ACCOUNT cascade;

create table ADMIN_ACCOUNT (
    id int8 not null,
    created_date timestamp,
    PASSWORD varchar(255),
    USERNAME varchar(255),
    membershipType varchar(255),
    NAME_ID int8,
    primary key (id)
);

create table PERSON_NAME (
    id int8 not null,
    created_date timestamp,
    FIRST_NAME varchar(255),
    LAST_NAME varchar(255),
    MIDDLE_NAME varchar(255),
    account_id int8,
    primary key (id)
);

create table USER_ACCOUNT (
    id int8 not null,
    created_date timestamp,
    PASSWORD varchar(255),
    USERNAME varchar(255),
    ROLE varchar(255),
    TENANT_CODE varchar(255),
    NAME_ID int8,
    primary key (id)
);

alter table ADMIN_ACCOUNT
add constraint FK_fil1krx8k0osj713tg44ia0vu
foreign key (NAME_ID)
references PERSON_NAME;

alter table PERSON_NAME
add constraint FK_hc1g7pa0rseytw9o1pcuo0mpw
foreign key (account_id)
references USER_ACCOUNT;

alter table USER_ACCOUNT
add constraint FK_ib2pk4at20vxm3onaoro6ry2r
foreign key (NAME_ID)
references PERSON_NAME;

Here's the command I have entered to flyway mvn compile flyway:migrate -Dflyway.schemas=tenant3,tenant4,tenant5 -Dflyway.baselineOnMigrate=true

这是我输入到flyway mvn compile flyway的命令:migrate -Dflyway.schemas = tenant3,tenant4,tenant5 -Dflyway.baselineOnMigrate = true

It's only generating the tables for the first tenant which is tenant3.

它只生成第一个租户的表,即tenant3。

Is this a bug? or am Missing something?

这是一个错误吗?还是错过了什么?

2 个解决方案

#1

To create multiple identical schemas you have to invoke Flyway once for each schema, with the flyway.schemas property set the to correct value. Flyway will then set the correct schema as the default one, letting you run your migration scripts unchanged (as long as you don't prefix the object names).

要创建多个相同的模式,您必须为每个模式调用一次Flyway,并将flyway.schemas属性设置为正确的值。然后,Flyway会将正确的模式设置为默认模式,从而使您的迁移脚本不会更改(只要您不为对象名称添加前缀)。

#2

Please find recommendations from flyway as in

请查找flyway的推荐信

http://flywaydb.org/documentation/faq.html#multiple-schemas

Hope this helps.

希望这可以帮助。