We use the carbon five plug-in: http://code.google.com/p/c5-db-migration/
http://code.google.com/p/c5-db-migration/
-- Each module stores its migration scripts in src/main/db/migrations
-- The migration is performed during process-test-resources phase. (This
will vary depending on your needs)
-- A Hudson CI server kicks off the updates
Parent POM
<pluginmanagement>
<plugins>
<plugin>
<groupId>com.carbonfive</groupId>
<artifactId>db-migration-maven-plugin</artifactId>
<version>0.9.7</version>
<configuration>
<url>${db-migration-maven-plugin.url}</url>
<username>${db-migration-maven-plugin.username}</username>
<password>${db-migration-maven-plugin.password}</password>
<goalPrefix>db-migration</goalPrefix>
</configuration>
<dependencies>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc14</artifactId>
<version>${oracle.ojdbc14}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</pluginmanagement>
Module Pom
<plugins>
<build>
<plugin>
<groupId>com.carbonfive</groupId>
<artifactId>db-migration-maven-plugin</artifactId>
<executions>
<execution>
<id>db-migration</id>
<phase>generate-test-resources</phase>
<goals>
<goal>migrate</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
Ryan Connolly wrote:
>
> Hi All:
> I was hoping someone out there in maven-users land would have
> some insight into how to manage database changes in a team environment
> that utilizes a dev db, a beta db used by apps built via continuous
> integration, a release candidate db, and a production db. I have
> looked briefly at liquibase as it is the only thing I've been able to
> find that does anything close to what we need for db change management
> but I'm running into a few issues with this. What do others use to
> manage db changes? I would be interested mostly in solutions that
> could be used in a continuous integration environment and am eager to
> learn what others know about this subject.
>
> Thanks in advance!
>
> -Ryan
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@maven.apache.org
> For additional commands, e-mail: users-h...@maven.apache.org
>
>
>
--
View this message in context:
http://n2.nabble.com/Plugins-for-Database-Change-Management--tp2684131p2686832.html
Sent from the maven users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@maven.apache.org
For additional commands, e-mail: users-h...@maven.apache.org
