Re: S-Designor
Date: 1996/07/10
Message-ID: <4rvq6i$6qv_at_romeo.logica.co.uk>#1/1
>I'm using version 4.2.1 of the Enterprise version. Here goes...
>: > Also, does this tool do any of the following?
>: > . Schema version control.
>Kinda. You can "archive" a pdm model at any point. An archive appears to
>be another pdm flat file with a different file extension. Archives allow you
>to generate changes between versions of the pdm. However, it only works on
>simple cases. Most of the time I generate a create table script (versus an
>alter table script) and I manually doctor the script to make the changes.
I agree it has the annoying habit of doing the following
reanme table to tmp_table
create new version of the table;
insert into table select values from tmp_table
drop tmp_table
This should work in theory but it often tries to insert hardcoded null values into not null columns even when the column value is available for selection from the tmp_table. This means the insert fails and as the next step is to drop tmp_table you lose your data.
I end up editing the files by hand and often wonder if it would be better to write them from scratch. I am running V4 as well maybe V5 will be better. In the meantime careful use of export is advised.
>By keeping the archives you could be said to have some form of version
>control.
We keep or module headers for tables indexes and views online in the annotation text. When we cut changes we post-process the files to rename to the correct filename (p2t_cal2.tab -> tab_cdep.sql) and add on the module header extracted from the database. This means all table scripts (1 table per script) are generated automatically with sensible names along with their change history.
We are looking at putting the pdm file under sccs (using uuencode to turn the binary into a text file). When we cut the first baseline we will probably put all the table,inxed view scripts under sccs. The post processing will then check the new version of the script into sccs.
Its nice to find other people using this tool in anger. Anyone using V5 yet ?
Darius Carr - carrdj_at_logica.com
It is highly unlikely that any opinions expressed match those of Logica "It is better to travel hopefully, than to arrive"
Received on Wed Jul 10 1996 - 00:00:00 CEST