Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What kind of database refactoring tools are there?

Tags:

I am looking for something to integrate to my CI workflow.
I've heard of dbdeploy but I'm looking for something else. The reason I don't like dbdeploy is I don't want to install java on my server.

I would prefer of course that the solution doesn't involve stringing some shell scripts together.

like image 964
paan Avatar asked Aug 26 '08 09:08

paan


People also ask

Which is achieved by database refactoring?

A database refactoring is a simple change to a database schema that improves its design while retaining both its behavioral and informational semantics. Database refactoring does not change the way data is interpreted or used and does not fix bugs or add new functionality.


2 Answers

Here is a feature comparison between

  • Flyway
  • Liquibase
  • c5-db-migration
  • dbdeploy
  • mybatis
  • MIGRATEdb
  • migrate4j
  • dbmaintain
  • AutoPatch
like image 197
Axel Fontaine Avatar answered Oct 13 '22 10:10

Axel Fontaine


It's not a tool, but Ambler and Sadalage's book, Refactoring Databases: Evolutionary Database Design is quite good.

like image 44
James A. Rosen Avatar answered Oct 13 '22 12:10

James A. Rosen