With a small database, you could consider rebuilding the database from scratch via SQL scripts possibly.
We had a similar problem with a much larger database though, using Oracle, and ultimately we opted to export the database using Oracle's tools to recreate the base environment. We did this with our JUnit tests which are integrated into our builds. Importing the master copy of the current version of the testing database proved to be far faster than loading it via scripts when the database size got large. I'm not personally familiar with postgresql but I would imagine there is some similar mechanic available. Just choose what is convenient for you now. You can always refactor the solution later. --- Phil Campaigne <[EMAIL PROTECTED]> wrote: > I am developing a java/tomcat/postgresql application using ant and > junit. I want to deploy tested builds along with matching tables > with > test data in them. > > What is the best way to version tables and data in the database to > match > a war file version? > thanks, > Phil > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
