Re: Database schema version control techniques
> From: Steve Wallick <uunet!pls.hisd.harris.com!spw@unifi.unifi.com>
> Subject: Database schema version control techniques
> Date: Wed, 24 Nov 1993 15:53:28 GMT
>
> It seems that there is some tools/tricks available.
>
> All responses appreciated
>
> Steve Wallick
> Harris Publishing
> spw@sur1a.ess.harris.com
Steve,
We keep a signature field as data in one of the tables.
The signature version string in the database matches the SCCS version of the
dbschema output (enhanced with extent sizes and dbspace information).
The value on the field helps determine the kind of upgrade (alter table etc)
to apply against a given schema.
Another *very important* thing to remember during upgrades is to have
sufficient locks and the logical log space. If logical log space is NOT
sufficient, turn logging off before attepting a conversion.
I have done such conversion many times (and have been burned many times) during
the product maturation phase.
Good Luck!!
Bharat
========================================================================
Informix-OnLine 5.01.UD5 SCO 3.0 Unix 3.2.4
Informix-Isql 4.11.UC1 AST 486/33
Informix-Esql/C 5.00
Wingz 1.10
Bharat Shah - Principal Database Engineer Voice: (508)-663-7570
Teloquent Communications Corp. Fax: (508)-663-7543
4 Federal St, Billerica, Mass 01821, USA bharat@unifi.com
========================================================================