Alternatives to DDLUtils from apache

Question

I would like to know which alternatives exist to replace DDL utils from Apache.

I ask this because ddlutils project seams to be Dead, and also it does not support H2 Databases. I've searched for it, and I found suggestions like liquidbase or flyway.

My problem is: These frameworks run when project starts and change DB structure based on some XML files. They are really designed for Database Migration.

What I want is a framework to CREATE/ALTER Tables in Runtime, in a high abstraction level., i.e. supportting at least Mysql, Sqlserver, oracle, and H2.

For example I could tell to the engine that I want to create a table with a Field AGE with Type Number, and the framework would rephrase to:

create table MY( id bigint(20))
create table MY(id bigint)
create table MY (id, number)

depending on the underlying db engine.

Any suggestions?

I could see there is a patch for ddlutils, for it to support H2. However I wasn't able to patch my svn checkout...

Any help will be appreciated.

thanks in advance rui

Have you found anything so far? – Gabriel C Mar 18 '16 at 16:52 — Gabriel C, Mar 18 '16 at 16:52
I need this also. @GabrielBR did you ever find anything? – mtyson Mar 31 '16 at 19:56 — mtyson, Mar 31 '16 at 19:56
would like to know of a good up to date framework on this – jacoviza Apr 09 '18 at 13:49 — jacoviza, Apr 09 '18 at 13:49

score 4 · Answer 1 · answered Aug 16 '18 at 12:30

I know this is an old thread, but wanted to give a definitive answer.

Yes, DdlUtils is dead, hasn't seen an update in 2 years now.

However, it looks like the guys might have switched over to https://www.symmetricds.org. Their repo is https://github.com/JumpMind/symmetric-ds.

As soon as you scratch away at the surface, you'll find that the core of DdlUtils is still in there (even has some of the old Apache copyright notices).

Class names have changed, APIs have changed so there is not a 1-to-1 mapping, but it is getting regular updates and includes H2 and other database support. Honestly I'd rather be getting those things instead of keeping the old APIs.

You're not going to find a guide on using Symmetric DS in the same way as the old DdlUtils doco, but there is enough in the code that you should be able to piece it together.

score 1 · Answer 2 · answered Apr 02 '21 at 07:52

Take a look on jOOQ it is very useful in generating DDL (and DML too)

create.createTable("table")
      .column("column1", INTEGER)
      .column("column2", VARCHAR(10).nullable(false))
      .constraints(
          constraint("pk").primaryKey("column1"),
          constraint("uk").unique("column2"),
          constraint("fk").foreignKey("column2").references("some_other_table"),
          constraint("ck").check(field(name("column2")).like("A%"))
      )
      .execute();

score 0 · Answer 3 · answered Apr 01 '16 at 16:20

0

This looks promising: https://bitbucket.org/aragot/play-sql-dialects/src

At least as a start.

answered Apr 01 '16 at 16:20

mtyson

8,196
16
66
106

score 0 · Answer 4 · answered Dec 22 '16 at 10:05

0

Mogwai ERD designer might help though they do not formally support H2 but you could put H2 into compatibility mode with one of the supported DB systems: https://sourceforge.net/p/mogwai

answered Dec 22 '16 at 10:05

Christopher Broderick

439
3
10

Alternatives to DDLUtils from apache

4 Answers4