Flyway is the Apache v2 licensed open-source tool that makes database migrations easy.
You can think of Flyway as version control for your database. It lets you evolve your database schema easily and reliably across all your instances. Flyway has been designed from day one to be easy to setup and simple to master. It strongly favors simplicity and convention over configuration. It achieves this by focusing on one problem only and solving it well.
Flyway has been built from the ground up for continuous delivery. We highly recommend you let Flyway migrate your database on application startup and you'll see that releases will never have been this easy.
It is based around just 6 basic commands: Migrate, Clean, Info, Validate, Baseline and Repair.
Migrations can be written in SQL (database-specific syntax (such as PL/SQL, T-SQL, ...) is supported) or Java (for advanced data transformations or dealing with LOBs).
It has a Command-line client. If you are on the JVM, we recommend using the Java API (also works on Android) for migrating the database on application startup. Alternatively, you can also use the Maven plugin, Gradle plugin, SBT plugin or the Ant tasks.
And if that not enough, there are plugins available for Spring Boot, Dropwizard, Grails, Play, Griffon, Grunt, Ninja and more!
Supported databases are Oracle, SQL Server, SQL Azure, DB2, DB2 z/OS, MySQL (including Amazon RDS), MariaDB, Google Cloud SQL, PostgreSQL (including Amazon RDS and Heroku), Redshift, Vertica, H2, Hsql, Derby, SQLite, SAP HANA, solidDB, Sybase ASE, Phoenix, EnterpriseDB and Greenplum
Flyway received the highest distinction on the Thoughtworks Technology Radar by being placed in the adopt category. Adoption has grown exponentially to reach 850,000+ downloads in 2015 alone:
Flyway Downloads
Enjoy migrating your databases with ease and pleasure!
Flyway is made with in München and is brought to you by Boxfuse, Axel Fontaine and the many contributors.
Boxfuse is the easiest, most reliable and secure way to run your JVM-based apps on AWS.
Just like Flyway, Boxfuse has been designed from day one to be easy to setup and simple to master. It strongly favors simplicity and convention over configuration and it has also been built from the ground up for continuous delivery.
Boxfuse is based on three core principles:
Boxfuse comes with powerful integration for Spring Boot, Grails, Dropwizard, Play, Tomcat, TomEE and executable jar applications. Deployment options include a command-line tool for Windows/Mac OSX/Linux as well as Maven and Gradle plugin for direct integration in your CI/CD process.
More info at boxfuse.com