Prev: How to alter the schema of a database to introduce new features or change the current features
Next: How to alter the schema of a database to introduce newfeaturesor change the current features
From: Paul M Foster on 15 Jul 2010 01:03
On Wed, Jul 14, 2010 at 09:28:53PM -0700, Slith One wrote:

> I'm developing an app using Zend Framwork using Git for version control.
>
> What is the best approach for updating the schema and the database
> when one of us makes an update to the db structure?
>
> currently, we have to blow out the tables and recreate them manually
> to reflect the new updates.

I'm probably being naive, but don't you have an ALTER TABLE sql
statement available to you?

Also, for what it's worth, I don't build tables manually (at the command
line or whatever). I always create a script which will build the tables
I need. If, for some crazy reason, I do have to restart from scratch,
it's a simple matter to alter that script and re-run it.

Paul

--
Paul M. Foster
 | 
Pages: 1
Prev: How to alter the schema of a database to introduce new features or change the current features
Next: How to alter the schema of a database to introduce newfeaturesor change the current features