Thread: Need a "development DB"

Need a "development DB"

From
Date:

Hi.  I would like to be able to have a version of a database for
production and one for development.  How can I set things up to
facilitate the process of updating the production database so that it
matches the current state of the development database?

Also, is there some form of revision control for databases?

Thanks!

kj


Re: Need a "development DB"

From
Kretschmer Andreas
Date:
kynn@panix.com <kynn@panix.com> schrieb:

>
>
> Hi.  I would like to be able to have a version of a database for
> production and one for development.  How can I set things up to
> facilitate the process of updating the production database so that it
> matches the current state of the development database?

You can use a different schema for development ans production.

>
> Also, is there some form of revision control for databases?

See http://pgfoundry.org/projects/tablelog/


Regards, Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)