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
project.
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.
Donnchadh
On 9/12/06, Christophe DENEUX <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
