Very Computer

I've been tasked to move a Progress version 6.2f database to another Unix
box that is running Progress version 6.3.

I was able to dump from the old system and ftp the resulting files to the
new system as well as the .db file, but that's where I'm stuck.

I've tried reading the Progress FAQ, and I would RTFM if the FM existed
here- no one here has a copy of the Progress Sys Admin docs.

Now that I have Progress installed on the new system, and the dump file, and
.db file there too, what's the best way to load the database on the new
system?

TIA
Greg

Quote:> I've been tasked to move a Progress version 6.2f database to another Unix
> box that is running Progress version 6.3.

> I was able to dump from the old system and ftp the resulting files to the
> new system as well as the .db file, but that's where I'm stuck.

> I've tried reading the Progress FAQ, and I would RTFM if the FM existed
> here- no one here has a copy of the Progress Sys Admin docs.

> Now that I have Progress installed on the new system, and the dump file, and
> .db file there too, what's the best way to load the database on the new
> system?

Of course v6 is obsolete and virtually unsupported -- this would be the
ideal time to upgrade to something modern like v8...

If you managed to dump the system then I'm assuming that you found the
data dictionary and used its dump option.  If so then you shouldn't have
too much trouble finding the "load" option (on the new system).  But 1st
you must create an empty database to load into.

With 6.3 one of the easiest ways to do that is to copy $DLC/emtpy.db to
whatever you want your new database to be named (assuming that this is
such a trivial system that a multivolume db isn't desired).

The startup the db and use the load option to load definitions (you did
dump those and transfer the .df file I trust...) followed by the data.  
Then all you need to do is recompile and away you go.

Hi,
I'm not sure if Progress 6.3 will accept a Progress 6.2f database.  To be on
the safe side, the best way I know to move a database from one version to
another is as follows:
Step 1:
Create an empty database in your new environment using prodb.  When asked
for the source database, just choose 'empty'.
Step 2:
Using the Administration utility, load the database schema files (previously
created in your 6.2f environment).  these files contain a series of SQL like
commands for creating the tables and indexes.
Step 3:
Load your table content files (once again, previously created in your 6.2f
environment).  These files contain an ASCII dump of your tables contents.

Michel Pelletier