What kind of database refactoring tools are there?

Question

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.

Axel Fontaine · Answer 1 · 2012-11-14T09:55:49.733

16

Here is a feature comparison between

Flyway
Liquibase
c5-db-migration
dbdeploy
mybatis
MIGRATEdb
migrate4j
dbmaintain
AutoPatch

edited Nov 14 '12 at 09:55

answered Jan 21 '11 at 20:21

Axel Fontaine

34,542
16
106
137

2

Is it me, or are these *all* Java tools? I (and OP) don't want to deploy a Java stack. – jameshfisher Mar 11 '13 at 20:29
1

This is not a complete or unbiased feature comparison either. – user761552 Oct 14 '13 at 19:40
Feel free to suggest improvements/corrections on the issue tracker at github.com/flyway/flywaydb.org – Axel Fontaine Oct 15 '13 at 04:29

score 6 · Answer 2 · answered Aug 26 '08 at 12:26

6

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

answered Aug 26 '08 at 12:26

James A. Rosen

64,193
61
179
261

score 5 · Answer 3 · edited Sep 29 '16 at 09:27

5

Redgate will probably do everything you need. Expensive though.

EDIT - Specifically: http://www.red-gate.com/products/sql-development/readyroll/

edited Sep 29 '16 at 09:27

David Atkinson

5,759
2
28
35

answered Aug 26 '08 at 09:56

Iain Holder

14,172
10
66
86

1

Redgate is, as "they" say, da bomb. – Kon Mar 18 '11 at 15:57

score 4 · Answer 4 · edited Jan 30 '13 at 03:18

You mentioned that you like dbDeploy and the fact that you do not want to install java on your server. Are you aware of the .NET port of this tool?

I used this recently with a team and we were very happy with it. In our case we were targeting SQL 2000, but it could easily be configured to run against other DB platforms, including MySQL. Of course it will require you to have the .NET Framework installed on the server... if that's an acceptable prerequisite vs. the java runtime.

score 2 · Answer 5 · edited Jan 30 '13 at 03:18

2

Possible it's not your case, but if you decide to use Java take a look at liquibase

edited Jan 30 '13 at 03:18

n00begon

3,503
3
29
42

answered Oct 04 '08 at 17:09

FoxyBOA

5,788
8
48
82

score 2 · Answer 6 · edited Jan 30 '13 at 03:17

2

for those people who are interested in liquibase, but don’t like xml migrations. Take a look at groovy-liquibase, a plugin that supports groovy migrations

Liquibase is great in structure, but misses with xml migrations. This plugin solves that problem

edited Jan 30 '13 at 03:17

n00begon

3,503
3
29
42

answered Mar 18 '11 at 15:56

Erwin van Brandwijk

21
1

score 1 · Answer 7 · answered Aug 26 '08 at 10:07

1

Yep, Redgate is magic. And Not that expenssive for what it provides.

answered Aug 26 '08 at 10:07

chrissie1

5,014
3
26
26

score 1 · Answer 8 · answered Sep 09 '10 at 10:17

Try Agile DBRIRE for Continuous Integration workflow. It's easy to set and allows to generate test db from Dev DB. Also it allows to generate incremental DB updates for Staging and Production. The tool can compare DEV and Staging/Production DB and generate metadata and data update SQL scripts. The tool is free.

score 0 · Answer 9 · answered Aug 26 '08 at 12:39

Visual Studio Team system (database edition) does some refactoring.

I read the Refactoring databases book. I think it's helpful.

But in software dev, you build tests so that you are safe refactoring. They don't touch on tests in the Refactoring Databases book, which was my big disappointment with it.

score 0 · Answer 10 · answered Aug 26 '08 at 12:53

I think those tools are very good, but for my purpose I have written a custom own. The main reason for this was because of I'm working on a SQL Server Compact 3.5 database, so none of the listed tools worked.

Of course it isn't as powerful as the tools from Redgate but you get the most important features very quick.

It's able to rename all kinds of database objects and migrating columns to other tables and create a diff script for 2 databases.

score 0 · Answer 11 · edited Jun 09 '19 at 07:04

0

An important part of Refactoring Databases is the migrations part. A .NET migrations solution that does not require EF or Java is Rob Reynold's Roundhouse

Might be worth checking out.

edited Jun 09 '19 at 07:04

Cœur

37,241
25
195
267

answered Dec 08 '16 at 17:55

8DH

2,022
23
36

What kind of database refactoring tools are there?

11 Answers11

Linked