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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Mag Gam 2007-11-20 15:59:19 need trigger help
Previous Message Shane Ambler 2007-11-20 07:02:07 Re: Database version control