Need help exporting data out of a Progress 8.2b database

gloc

New Member
Hello,
I need to be able to export the data from progress 8.2b database to text files, or csv files.

This data is from an old application that used progress as the database backend.
I'm the sys admin and basically inherited needing to get the data out and into something that can be searched if needed.
I know very little about the application, but have been able to determine it is using progress version 8.2b
I read that I should be able to use the data dictionary to export or dump the data out of the tables, but when I bring up the data dictionary application and connect to the database, the [admin] menu choice is grayed out.
I've downloaded and installed ODBC drivers 'openlink' for version 8.2a (8.2b was not listed as a choice), but it asks for parameters that I do have any idea what they should be.
The docs for the ODBC driver also said I need to run a setup.p to create a tableview .dat file
The instructions for this said to run $DLC/bin/pro -p setup.p
There is no pro application, if I look in that directory I find proctrl.exe, prodb.exe, prodel.exe, prolib.exe, prolog.exe, prosrvc.exe,prowin.exe, plus quite a few other executables, but no pro.exe

Does anyone have any ideas I can try that will let me dump or export the data from the tables to text files of some sort?


The environment the application and progress are running on:
Windows 2003 Standard Server Service pack 2 32bit
This machine is being done away with, and the application is no longer used - BUT the data is very important for historical reasons.
The application/progress installation disks are long gone apparently, and the company that did the app no longer provides any support for it.


Thanks ahead of time for any help someone might be able to provide.

Gerry
 
See Progress Knowledge Base.

Add -rx to the shortcut that you are using to start the data dictionary / data administration and you should be able to access the dump data menu. The ascii dump (.d files) are SPACE delimited.

Sorry, a bit too quick. -rx will not allow you to dump / load data.

How big is the database and how sensitive is the data?
 
In that case:


  1. hire someone in who does have a 8.2 / 8.3 development license handy - not sure how this works licensing-wise
  2. get in touch with progress and make a deal to borrow an 8.2 development license for a day
  3. in the past (over 10 years ago) I have managed to get the 8.3 open interface broker thing working on windows 95 or so but it was never a pleasant experience - to make it even nastier - I think 8.2 is a 16-bit version (hence prowin.exe instead of prowin32.exe)... good luck!
 
Back
Top