maven-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donnchadh Ó Donnabháin" <>
Subject Re: Database deployment
Date Mon, 18 Sep 2006 12:05:08 GMT
At first I used the maven exec plugin to run a shell script, but now
I'm switching to the sql-maven-plugin, both from the codehaus mojo

sql-maven-plugin seems to be exactly what I was looking for.

other options would have been dbunit for data and using hibernate
(maybe via the maven exec plugin) to generate generate the schema.

Once we have a released version we also plan on running migration scripts.


On 9/12/06, Christophe DENEUX <> wrote:
> We plan to use the ant task "exec", and its attribute "os" to manage the
> difference between operating system.
> Our projects use an Oracle database, so the "exec" task will execute
> "sqlplus" with a sql script file.
> We plan to follow this way during the life of our project:
>     a) for the first release (V1), we will use the "exec" ant task to
> drop and create the V1 database schema,
>     b) when the V1 will be released, we will export the schema (data and
> DDL) in a dump file
>     c) for the next release (V2), according to the possible project
> installation (from scratch, or over the previous version), we will use:
>            c1) for "from scratch" case: "exec" ant task to drop and
> create the V2 database schema,
>            c2) for "over the previous release" case: "exec" ant task to
> drop, import V1 dump file and migrate from V1 to V2 with the database
> patch script,
> Our projects that are planned to use this way, have an manual
> installation procedure (helped by scripts)

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message