Best open-source database schema migration tool to automate migrations?

This page summarizes the projects mentioned and recommended in the original post on /r/devops

Our great sponsors
  • Sonar - Write Clean Java Code. Always.
  • Mergify - Updating dependencies is time-consuming.
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • Sequelize

    Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.

    Our main apps are written in Node.js and there we use TypeORM for some of the lighter CRUD. I've looked into TypeORM migrations but get the impression that the CLI tool is not up to date. I've also looked a bit at Sequelize (but that would require us to switch from TypeORM).

  • liquibase

    Main Liquibase Source

    Liquibase seems competent but maybe to much and Java heavy?

  • Sonar

    Write Clean Java Code. Always.. Sonar helps you commit clean code every time. With over 600 unique rules to find Java bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • Flyway

    Flyway by Redgate • Database Migrations Made Easy.

    Flyway seems similar

  • migrate

    Database migrations. CLI and Golang library.

    golang/migrate seems nice, decently light weight and with a decent size community?

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts