DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=OPMLZbiR85lUARpT2NoCR0Gpn2EgBhUz6zoL9zMs2nGiUJvlf/+OQErocyuMs0/R3rNmAXepLoBZbEHP+zcGruQwobmH5f9Pv/Aim2v2Q3YWKTl7I5tlQ+eetUaf5bs531V6XiPY6qcgAZaDRZXOzqWYEnG2bLqvdW5Ihm3II6I=
Message-ID: <8078a1730804181152m199faeb5j47efa7c72a9571c7@mail.gmail.com>
Date: Fri, 18 Apr 2008 11:52:57 -0700
From: "Medi Montaseri" <montaseri@gmail.com>
To: postgresql-admin <pgsql-admin@postgresql.org>
Subject: Dev Process
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_6589_550264.1208544777088"

------=_Part_6589_550264.1208544777088
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

I was wondering if you could critique the following DB application
development process.

Given a production DB and a Dev DB:
1- Develope schema and code on Dev including test data which will impact
sequences, etc
2- Dump the schema only (not the data) from Dev and restore it into the
production DB
3- Populate DB with real data, usage begins
4- Enhancement to schema on Dev DB including unit testing again with impact
on sequences
5- Dump schema and move to production
6- Goto 4

Thanks
Medi

------=_Part_6589_550264.1208544777088
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,<br><br>I was wondering if you could critique the following DB application development process.<br><br>Given a production DB and a Dev DB:<br>1- Develope schema and code on Dev including test data which will impact sequences, etc<br>
2- Dump the schema only (not the data) from Dev and restore it into the production DB<br>3- Populate DB with real data, usage begins<br>4- Enhancement to schema on Dev DB including unit testing again with impact on sequences<br>
5- Dump schema and move to production<br>6- Goto 4<br><br>Thanks<br>Medi<br><br><br>

------=_Part_6589_550264.1208544777088--