Check out Liquibase. (www.liquibase.org). You'll save yourself a lot
of headaches managing schemas for two different database vendors, and
there is an excellent Maven plugin for it, as well.
Cheers -
Dave
On 02/06/2012 08:18 AM, Ilia Ternovich wrote:
Hi!
I need to deploy two different database schemas (DDL as well as some
dictionary data) to multiple databases during my build process (e.g.
Oracle and Derby databases).
The question is similar to old one:
http://www.mail-archive.com/[email protected]/msg02440.html but
it is unanswered and I'm really short in documentation with plugin.
As far as I understand from documentation:
http://mojo.codehaus.org/sql-maven-plugin/usage.html I need several
executions, right? What I want is to type mvn sql:execute_derby (or
mvn sql:execute_oracle) and plugin will deploy custom sql scripts onto
the database. How can I achieve this?
Thanks!
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
