On Fri, 25 Mar 2005 14:28:14 -0800, Rich Pinder <rpinder@...> wrote:

> ONLY use the DDL up on the 'live' database - then after its working,
> just GBAK the 'live' one up, and restore it on my test machine (where I

I do this. I back up the 'live' db and restore it on the test machine
and then do my development from the test machine, then I make the
necessary changes to the 'live' db after making another backup of
course. Then the next time I need to work on applications that deal
with the 'live' db, I start back over by taking a backup and moving it
down to my test machine.

I have never lost any changes although sometimes I have been worried
because of the number of changes that I need to make to the db. I also
subscribe to small incremental changes instead of big sweeping ones...
that might help out my situation a little.

Hope this helps.
Ray