Re: Dealing with Table Structure Changes Between Production and Development Server?

[Erin ONeill]

I think there are many ways to accomplish this -- depending on the slant of the systems in use where you are. I've always used CVS since I'm a unix geek and I work in places where UNIX is the standard. I'm comfortable with unix scripts and the command line. In the past I've combined CVS, unix scripts with cron to do this sort of thing.

It's usually built into the build & release system. Once the QA manager releases the change/update then the build & release person sets the release in motion, a script gets setup to run (at a time that works for everyone) and viola! change has been pushed to the produciton server.

Of course now i'm at a smaller company and there is no build & release and ppl apply by hand with phpMyAdmin which just gives me the willys! but so far it works.

erin