My FeedDiscussionsHeadless CMS
New
Sign in
Log inSign up
Learn more about Hashnode Headless CMSHashnode Headless CMS
Collaborate seamlessly with Hashnode Headless CMS for Enterprise.
Upgrade ✨Learn more

What do you use for database migrations

Mark's photo
Mark
·Jan 8, 2019

I'm kind of looking for a RMDB migration tool. Ideally one that:

  • Isn't tied to an application framework (e.g. it can use some programming language for its operation, but shouldn't push me to use that language for the rest of my own application).
  • Works for many SQL dialects.
  • Free (gratis) & open source.
  • Easy to install and run (preferably not rocket science to write).

And nice to have:

  • Backward migrations are nice, but not required.
  • Ideally can be put in VCS to match data and code versions. So e.g. no consecutive numbering, as that gets messed up when there are many concurrent feature branches.
  • Nice if it supports schema and data migrations.
  • Squashing migrations would be nice.
  • Plugins

No need to generate access code (ORM stuff), those can be based on the resulting schema.

So my question is: what do you use?