Upgrading

[Chris Kelleher]

Greeting

I was just given the task of upgrading RoundTable from 8.1a to 8.3b and
moving RoundTable from SCO UNIX to Windows NT. I have used RoundTable
from the programmer side for checking items out and moving code between
workspaces but I have no experience with what is needed to move from
UNIX to NT and changing versions. There seems to be no documentation
that anyone can find either.

We are currently running RoundTable on SCO UNIX version 8.1a. Here is
a list (I'm not sure if you need to know this) I was given of the
different RoundTable/PROGRESS products we have:

* 4 gl version 8.1 for SCO
* 4 gl version 8.3b for SCO
* Provision version 8.1 for windows
* Provision version 8.3b for windows
* RoundTable version 8.1a for SCO
* RoundTable version 8.1a for Windows
* RoundTable version 8.3b for Windows

Any guidance that can be given will be greatly appreciated.

Thanks
Glenda

 

[Chris Kelleher]

Glenda,

As the databases are not binary compatible, you will have to dump and load
the Roundtable databases un SCO Unix and then load it into a Windows
database (unless you want to keep the databases in UNIX - that would be the
easiest). Make sure that you use the Roundtable dump/load utilities and not
the data dictionary dump and load procedures. Roundtable makes extensive use
of RECID and the repository will therefore be damaged and useless if you do
a normal dump / load. The utilities are located in the rtb_util directives
off the Roundtable installation directories.

>From a procedure editor in a Roundtable / Progress session, run the
following code :

RUN rtb_util/rtb_dmp1.p.

This will dump the repository into a number of .d files that can then be
transferred to the Windows server. Make sure that you do not lose any code
page information if you are using special code pages.

The create a new empty database on the windows server and load the schema
definitions into the database using the Roundtable installation programme.
You may be able to save yourself a lot of time by doing this in 8.3B
directly (I was going to suggest first creating an 8.1A database, loading
the data and the running the update utility to update to 8.3B - but I don't
think this is necessary).

Compile the 8.3B windows client against the new empty database.
Start the RTB client and from a procedure editor under the RTB / Progress
session, run the following code:

RUN rtb_util/rtb_lod1.p.

For both the run statements it may be necessary to add the following PROPATH
statement to before the run statement :

PROPATH = PROPATH + ",/roundtable". (replace "roundtable" with the root
directory of the RTB installation).

Once this is done, you should be up and running.

As there are a number of database changes in RTB between 8.1A and 8.3B, you
may have to go through the extra steps if first creating an 8.1A RTB
database to load into, and then updating the database schema with the
Roundtable set-up procedure as this will avoid problems with missing tables
and field during the database load.

Note that the dump / load can take a very long time if your database is big.
It is much slower than the normal dump / load, and there is nothing really
you can do to speed it up.

HTH - let me know if it does not.

Regards

Thomas
___________________________________
Hansen IT Consulting
Frilandsvej 85
9800 Hjørring
Denmark

Tel.: +45 98 90 49 16
Fax.: +45 98 90 49 17
Mobile : +45 20 16 19 29

E-mail : thomas@hansenit.dk
Web : www.hansenit.dk
__________________________________
StarBase Corporation StarPartner and
Certified Roundtable Consultant

*** COMING SOON - Future Proof RAD Progress Development ****
!! Astra Development Framework and AstraGen Global Application Module !!!

 

[Chris Kelleher]

PS- I forgot to mention that you should make sure that you download the
patch 8.3B02 from the Roundtable web site : www.roundtable-tsms.com. This has a number of important fixes.

Thomas