Sorry Ilia,
I wasn't thinking of the immediacy of your problem. In the past, when I
have used the maven-sql-plugin, I've always done so as part of a Profile
so that I can simply execute it at will, as opposed to being part of a
build. You could create separate profiles for each execution and avoid
the confusion of having two executions defined for the plugin.
It looks like you have another solution in hand already, though.
I really would encourage you to check out Liquibase, though. I've found
it to be a wonderful tool for managing schema evolution in a generic
way. It has its own concept of "profiles" built in, as well. This lets
you easily define which type of database you want to build when you
execute it.
Good luck!
Dave
On 02/06/2012 09:48 AM, Ilia Ternovich wrote:
Hi Dave!
Thank you for rapid answer. I *do* have schemas prepared. I need to
deploy them using existing sql-maven-plugin but due to the lack of
documentation want to help someone with my original questions. Anyways
thanks!
2012/2/6 Dave Hicks <[email protected] <mailto:[email protected]>>
Check out Liquibase. (www.liquibase.org
<http://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
