Flyway is an

open-source Open source is source code that is made freely available for possible modification and redistribution. Products include permission to use the source code, design documents, or content of the product. The open-source model is a decentralized sof ...

database-migration tool.

Concept

Flyway is based around seven basic commands: Migrate, Clean, Info, Validate, Undo, Baseline, and Repair. Migrations can be written in SQL (database-specific syntax such as PL/SQL,

T-SQL Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, vario ...

, etc is supported) or

Java Java (; id, Jawa, ; jv, ꦗꦮ; su, ) is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea to the north. With a population of 151.6 million people, Java is the world's List ...

(for advanced data transformations or dealing with LOBs). It has a command-line client, a Java API (also works on

Android Android may refer to: Science and technology * Android (robot), a humanoid robot or synthetic organism designed to imitate a human * Android (operating system), Google's mobile operating system ** Bugdroid, a Google mascot sometimes referred to ...

) for migrating the database on application startup, a Maven plugin, and a Gradle plugin. Plugins are available for

Spring Boot Spring(s) may refer to: Common uses * Spring (season), a season of the year * Spring (device), a mechanical device that stores energy * Spring (hydrology), a natural source of water * Spring (mathematics), a geometric surface in the shape of a ...

, Dropwizard, Grails, Play,

SBT sbt is an open-source build tool for Scala and Java projects, similar to Apache's Maven and Gradle. Its main features are: *Native support for compiling Scala code and integrating with many Scala test frameworks *Continuous compilation, t ...

, Ant, Griffon,

Grunt Grunt, grunts or grunting may refer to: Sound and music * Grunting (tennis), in tennis refers to the loud noise, sometimes described as "shrieking" or "screaming", made by some players during their strokes * Death grunt, the death metal singin ...

Ninja A or was a covert agent or mercenary in feudal Japan. The functions of a ninja included reconnaissance In military operations, reconnaissance or scouting is the exploration of an area by military forces to obtain information about enem ...

, and more. Supported databases include

Oracle An oracle is a person or agency considered to provide wise and insightful counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. As such, it is a form of divination. Description The word '' ...

, SQL Server, DB2,

MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database o ...

(including

Amazon RDS Amazon Relational Database Service (or Amazon RDS) is a distributed relational database service by Amazon Web Services (AWS). It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational dat ...

, Aurora MySQL, MariaDB), Percona XtraDB,

PostgreSQL PostgreSQL (, ), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the In ...

(including

and Heroku), Aurora PostgreSQL, YugabyteDB, CockroachDB,

Redshift In physics, a redshift is an increase in the wavelength, and corresponding decrease in the frequency and photon energy, of electromagnetic radiation (such as light). The opposite change, a decrease in wavelength and simultaneous increase in f ...

Informix IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings. The Informix products were originally developed by Informix Corporation, whose I ...

, H2, Hsql,

Derby Derby ( ) is a city and unitary authority area in Derbyshire, England. It lies on the banks of the River Derwent in the south of Derbyshire, which is in the East Midlands Region. It was traditionally the county town of Derbyshire. Derby gai ...

SQLite SQLite (, ) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the most ...

SAP HANA SAP HANA (HochleistungsANalyseAnwendung or High-performance ANalytic Application) is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as the software running a databas ...

Sybase ASE SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model database server developed by Sybase Corporation, which later became part of SAP AG. ASE was ...

, Phoenix, and

Firebird Firebird and fire bird may refer to: Mythical birds * Phoenix (mythology), sacred firebird found in the mythologies of many cultures * Bennu, Egyptian firebird * Huma bird, Persian firebird * Firebird (Slavic folklore) Bird species ''Various spe ...

Adoption

Flyway received 11,500,000 downloads in 2018. In January 2015, Flyway was placed in the "Adopt" section of the Thoughtworks Technology Radar. In July 2019, Flyway was acquired by

Redgate Redgate Software is a software company based in Cambridge, England. It develops tools for developers and data professionals and maintains community websites such as SQL Server Central and Simple Talk. Redgate produces specialized database mana ...

.{{Cite web, url=https://www.realwire.com/releases/Redgate-cements-position-as-leading-vendor-with-Flyway-acquisition, title=Redgate cements position as leading vendor with Flyway acquisition, website=www.realwire.com, date=24 July 2019 , language=en, access-date=2019-08-19

Related tools

* DBmaestro * Liquibase

References

External links

Flyway Home
Database administration tools Java platform Agile software development Software using the Apache license