How to use flyway to migrate data from one DB to another DB?

Question

I have two postgreSql DB on different server lets say A and B. Can I use flyway some how to copy all data from DB A to B which is newly setup and empty. Its will be helpful if anyone point me to correct direction and tool, requirement is to copy data from one DB to another through some tool automation huge data volume need to consider in solution.

Don't use something slow and complicated to copy a large database. Use pg_dump and pg_restore. — Laurenz Albe
– Laurenz Albe, Commented Aug 22, 2019 at 5:52
pg_basebackup if you want to copy the whole PostgreSQL cluster, not just some single DB. — Abelisto
– Abelisto, Commented Aug 22, 2019 at 16:44
@LaurenzAlbe thanks , migrate word used in flyway some how confusing for me, I understand now its involved manual script generation and need to feed to flyway for migration and no direct solution. — Gan
– Gan, Commented Aug 23, 2019 at 10:50

Mikiel · Accepted Answer · 2019-08-22 13:11:00Z

6

Flyway doesn't directly support such a capability. However, you could do the following:

As Laurenz says, use pg_dump to extract DB A into a script file
Create a Flyway migration script and copy in the contents of the script file
Run the Migrate command against DB B

answered Aug 22, 2019 at 13:11

Mikiel

4483 silver badges10 bronze badges

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

1 Comment

Stepan Mozyra Over a year ago

Sometimes this couldn't be an option as it's requires service downtime.

Collectives™ on Stack Overflow

How to use flyway to migrate data from one DB to another DB?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest