well, i'm using the hibernatetool ant tasks which would pretty well for printing the current schema (not the one on the server) and for creating/updating tables. the only thing is that the update function is not all that great and misses a lot of stuff. i think i've got a pretty good solution based on some suggestions on the hibernate forums but i'll keep you informed.
On Tue, 2005-12-06 at 12:34 -0800, Patrick Casey wrote: > Currently, I'm doing database dumps from my dev instance and loading > them into my test box (via the mysql dump utility). This is problematic > though as it's destructive vis-à-vis the test instance. > > I thought at one point I'd be able to use Hibernate's XML export > tools to dump relevant data out of one instance and into another, but the > Hibernate XML tools are *not* ready for prime time. They don't handle > recursive graphs well, then dump core on some types of data (lists of > scalars for example), etc. Worse, the JIRA items I opened on the subject > aren't scheduled for fix until 3.2 :(. > > I toyed with the idea of writing my own load/unload code but haven't > bit off that particular bullet yet. It's not complicated, it's just ... > tedious and there's always something more important to work on in my > experience. > > So if you find a good solution, I'd love to hear it, but in the > interim, rest assured, you're not alone on this issue. > > --- Pat > > > -----Original Message----- > > From: Dan Adams [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, December 06, 2005 12:12 PM > > To: Tapestry users > > Subject: [very OT] tools for migrating database > > > > I have a testing server which runs locally and then a staging server > > which actually gets tested on by other people and is updated after each > > iteration. I use hibernate. Does anyone know of a way to update the > > staging server database to sync up the schema with the test database > > (the current schema) without blowing away the data? I currently use > > mysql on both servers but am planning on moving the test server to > > hsqldb at some point it can't be a server specific tool. Any ideas? > > > > -- > > Dan Adams > > Software Engineer > > Interactive Factory > > > > > > --------------------------------------------------------------------- > > 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] > -- Dan Adams Software Engineer Interactive Factory --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
