We use the ant sql task to do this in the build section of the pom, in conjunction with DBUnit tests:
<build> <plugins> <plugin> <artifactId>maven-antrun-plugin</artifactId> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>3.0.10</version> </dependency> </dependencies> <executions> <execution> <id>sql-test-compile</id> <phase>test-compile</phase> <configuration> <tasks> <sql driver="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1/" userid="user" password="pass" onerror="continue"> <transaction> drop database my_db; </transaction> <transaction> create database my_db; </transaction> <transaction src="src/main/resources/database/mysql/load_test_data.sql"/> </sql> </tasks> </configuration> <goals> <goal>run</goal> </goals> ...etc Hope this helps. Kieran > >no, they're just databases (SQL) (by schema i mean definitions of tables >and stored procedures) > >andrew > >Piéroni Raphaël wrote: >> Do your database schema use Torque oà r hibernate ? >> >> Raphaël >> >> 2006/2/21, andrew cooke <[EMAIL PROTECTED]>: >>> >>> >>> Hi, >>> >>> I have a DB schema that defines a database. I'd like Maven to manage >>> this >>> (so that I can delete/re0create the database before tests, for example). >>> How do I do this? >>> >>> Thanks, >>> Andrew >>> >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >> > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]