Export Data from a Progress 4.2a Database

On Dec 13, 5:47 pm, "SilentWing" wrote:
> Hi Folks:Back in 1987 (yes 20 years ago), one of my employment ancestors
> wrote a DB in Progress 4.2a.I have been given the task to figure out a way to
> extract the data (preferably into excel or Access) with eventual importing
> into MySQL. Any idea where I can find an ODBC connector for 4.2a (if one
> exists), or how else I can extract the data - text files would be acceptible.
> The size is tiny. The .db file is 105kb and the .bi file is 256kb.
> Any help would be greatly appreciated.
>
> --
> Regards,
> SilentWing
>
> If it is to be, it's up to me!

There is no ODBC connector for 4.2a.

You'll need to dump the data into a flat file through the data
dictionary and then reload it into a more modern version of progress
(aka 10.1b.) From there you can make an ODBC connection.

I have code that exports schema and data from Progress into MySQL and
PostgreSQL via SQL statements, but I can guarantee you it won't work
on anything short of 9.1e.

If you want the code, send me email at scottauge at gmail dot com -
it's libre open source, I'll just send ya a zip file.

If you don't have a budget for a newer version of Progress, ya get to
make some hours dumping the data into a format the data dictionary can
handle and re-massaging it into what you need.
 >> Stay informed about: Export Data from a Progress 4.2a Database