Source control/release management for databases

• Flyway

  81 7,763 7.2 Java

  Flyway by Redgate • Database Migrations Made Easy.

  

I realize I got off on the tangent of release planning without mentioning how we actually managed our DB schema. It's been a while so I've forgotten some of the details. We used, if I recall correctly, flyway, and could reproduce a production DB from scratch with all the alters from the beginning. Any DB change was done in the form of a DDL script run through flyway. Manually, at the command line, for development, but then integrated was a Maven plugin for test and production deployments.

• roundhouse

  5 916 2.8 C#

  RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control

  

Have a look at roundhouse too, if you have SQL experienced people this should be easy to use. All the migrations are basically sql scripts that you can version control. https://github.com/chucknorris/roundhouse

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project