Here's what I do.
I run a cron job every night that takes the current production backup,
builds a new dev database, then runs a directory of sql that updates the
schema (or data). At first people complained they lost schema changes but
pretty soon they learned to create a file, run it then copy it
Maybe you can try Kettle:
http://www.kettle.be/
m2f
Sent from www.TapestryForums.com
Read this topic online here: <>
http://www.tapestryforums.com/viewtopic.php?p=11533#11533
m2f
To: Tapestry users
> Subject: RE: [very OT] tools for migrating database
>
> Perhaps:
> http://octopus.objectweb.org/
>
>
> Patrick Casey <[EMAIL PROTECTED]> wrote:
> Currently, I'm doing database dumps from my dev instance and loading
> them into my test
erim, 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 migr
ays 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,
o 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
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)
