Skip site navigation (1) Skip section navigation (2)

Re: Database version control

From: Emil Oppeln-Bronikowski <emil(dot)oppeln(dot)bronikowski(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Database version control
Date: 2007-11-20 07:08:27
Message-ID: 1195542507.29308.9.camel@heroina (view raw or flat)
Thread:
Lists: pgsql-novice
Dnia 19-11-2007, Pn o godzinie 22:46 +0200, Alex du Plessis pisze:

> Is there any way to do version control on a database from one 
> application version to another?

	I just have database structure near code and I manage it with
Subversion. But my favorite way to keep changes visible is to have basic
structure and keep all ALTER queries in files. Then I have
00BasicStruct.sql 01PasswordField-20071212.sql and so on, After I'm
close to freeze, I build clean structure and dump it into Subversion
repo


In response to

Responses

pgsql-novice by date

Next:From: Mag GamDate: 2007-11-20 15:59:19
Subject: need trigger help
Previous:From: Shane AmblerDate: 2007-11-20 07:02:07
Subject: Re: Database version control

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group