Database Migration with the flyway or dbup(.net library/dbup extension) with PostgreSQL

3k views Asked by At

First of all, I am sorry because it might be a stupid question but after a day research I am confused and I have a very less time to decide.

We are using TFS as a CI tool and as an SCM. And Postgresql for DB. Planning to Automate DB with Postgresql and TFS.

Please suggest a tool for this that I can go forward with running my SQL files on specific DB as I want.

Can anyone please tell me if I use DbUp Migration Extension of TFS is it supporting Postgresql? As this link shows it only works with Microsoft SQL Server or Microsoft SQL Azure and then another Document says DbUp supports a number of different databases including Postgresql.

also, Does Flyway have support for c# and TFS ?

1

There are 1 answers

4
Mikita Karaliou On BEST ANSWER

Most popular tools to do what you want is Liquibase and Flyway.

As I know there is only one significant difference: Flyway - plain SQL based, Liquibase - provides abstraction level based on XML, JSON or YAML as well as plain SQL. You can use abstractions (provided by Liquibase) to increase portability of your scripts.