Ingres 6.4 -> OpenROAD upgrade

barryp@iinet.net.au (Barry Pritchard) wrote:
>Information request:	Could anyone provide me with information
>relating 			
>			to the stumbling blocks I could expect and possible
>			work arounds to converting from Ingres 6.4 & W4gl
>			to OpenROAD.
>
>Current Env:	UNIX workstations, Motif - Ingres 6.4 & W4gl
>		Application makes use of operating system calls (sed, awk, shell).
>		Some C routines
>		FrameMaker (UNIX version).
>		Database 5 - 10GB range.
>
>Target Env:	Mixture of UNIX workstations and PC (Win95)
>		More choice on other tools (eg. MS-Word, EIS, Ad-Hoc reporting).
>
>Objective:	Reduce reliance on single platform.
>
>

2 weeks ago I migrated our production systems from W4GLv2 to OpenROAD. We use
UNIX (Solaris 2.4) and Ingres 6.4. We have 7 main applications with 600K lines
of
4GL code.

The only code changes required were to remove some # symbols present in some of
our code.

The screens had to be re-arranged as the size of buttons and entry fields had
changed and overlaps occurred. I had to create a colour table to customise the
colours we used in version 2. The standard OpenROAD colours were terrible.

Once all that was done, everything worked fine. All our calls to C routines
worked, operating system calls, dynamic 4GL processing we do all worked with no
problems. The migration went very smoothly and easily.

Hope this helps some.

Mark
-- 
wwgebm@lpdwhy.bhp.com.au is
Mark GEBBIE             +-------------------------------------------------+
BHP-IT Whyalla          | Here I am, brain the size of a planet and they  |
PO Box 21,              | want me to take you up to the bridge.           |
Whyalla S.A.  5600      |                 -- Marvin, The Paranoid Android |
Ph: +61 86 40 4588      +-------------------------------------------------+
Ingres Q & A
To William's Home Page

© William Yuan 2000

Email William