Re: Version Control How?

From: Mauro Fossa <fossa_at_its.it>
Date: 1996/05/07
Message-ID: <4mn364$n8c_at_ns1.its.it>#1/1


dmarsha3_at_csc.com (dmarsha3) wrote:

>Group :
 

>I get new ddl for every 2 weeks from my developers. I was looking if there
>is any facility on Unix or Windows which allows me to keep a version control of
>each ddl and should be able to identify the changes between the versions so that
>I can further refine it and have delta changes and apply it on to the existing one
>and bring it to current .

I doubt a *canonical* version control software will solve your problems. Imagine version #1 for a table is

	CREATE TABLE TEST (
		FLD1 CHAR(10),
		FLD2 CHAR(20)
		);

Now, version #2 is

	CREATE TABLE TEST (
		FLD1 CHAR(13),
		FLD2 CHAR(20),
		FLD3 INTEGER
		);

Most version control programs, such as sccs, rely on basic line-by-line comparison (see also diff)

	% diff v1.ddl v2.ddl
	2,3c2,4
	<   FLD1 CHAR(10),
	<   FLD2 CHAR(20)
	---
	>   FLD1 CHAR(13),
	>   FLD2 CHAR(20),
	>   FLD3 INTEGER

from that you need to extract ALTER TABLE statements. Similar processing is to be done for storage information (tablespace, PCTUSED, PCTFREE), primary and foreign key constraints, indexes etc.

It seems pretty hard to me, unless I'm missing something obvious.

>Any help is appreciated.
 

>Rama
>kramakri_at_dayton.csc.com

(BTW, fix your From: and Reply-to: addresses in your browser preference panel)



Mauro Fossa (fossa_at_its.it) Received on Tue May 07 1996 - 00:00:00 CEST

Original text of this message