Migrate sql schema to many databases using Flyway

Asked Sep 20 '16 at 12:30

Active Sep 20 '16 at 18:27

Viewed 109 times

I'm trying to write a simple Java sample application which uses Flyway to migrate many databases on one IP. When I run this application it completes without error but nothing seems to happen, the schema_version table is not created.

public static void main(String[] args) {
    ApplicationContext ctx = new ClassPathXmlApplicationContext("databaseConfig.xml");
    ClientDAO clientDao = ctx.getBean("clientDao", ClientDAO.class);
    List<String> clients = clientDao.getClients();
    Flyway flyway = new Flyway();
    for (String client : clients) {
        flyway.setDataSource("jdbc:mysql://" + STAGE_DB_IP +"/" + client, DB_USER, DB_PASSWORD);
        flyway.baseline();
        flyway.setBaselineOnMigrate(true);
        flyway.migrate();

    }
    System.out.println("Done");
}

The databases already exist with tables.

edited Sep 20 '16 at 18:27

markdsievers

7,151
11
51
83

asked Sep 20 '16 at 12:30

Владимир Гичев

Have you checked if clients List has any value? – Ricardo Vila Sep 20 '16 at 12:31
Yes. clients List contains names of all databases – Владимир Гичев Sep 20 '16 at 13:11
Update: When i comment flyway.migrate() it start creating me schema_version table.... – Владимир Гичев Sep 20 '16 at 13:56
Maybe flyway cannot find migration files? – Ricardo Vila Sep 20 '16 at 15:22
Few things. 1) Your call to `Flyway.baseline` is redundant, `Flyway.baseLineOnMigrate` will do that for you when calling `Flyway.migrate`.. 2) After `Flyway.migrate` use the `MigrationInfoDumper` with the output of `Flyway.info` to get the state of things. Update the question with that output if that doesn't help you solve it. 3) I don't know what the default schema is on MySQL, but I'd be looking in the equivalent of the `public` schema for `schema_version` – markdsievers Sep 20 '16 at 18:36
After a couple of hours i used flyway.setLocations("filesystem:C:/db"); And it started working. The default classpath db/migration was not working..... – Владимир Гичев Sep 23 '16 at 08:52

Migrate sql schema to many databases using Flyway

0 Answers0