Using MySQL with Progress

[Kopperton]

I have a Linux server with MySQL installed.

We have another server with Progress 9.1E installed. This is our main server.

I like to retrieve 5 tables and most of fields in each table from a Progress database server to Linus MySql sever.
Like to run this daily(I'll use cron)

Can this be obtained? Show me how.:blush: Thank You All.

 

[Cappie]

we use something similar, but from progress 10.1c and MySql windows version.

Create a dump file. (*.d) from progress db.

Import into Mysql using :
LOAD DATA LOCAL INFILE 'C:/Projects/Proclin/Wellness2/DatadumpJaco/accounttype.imp'
INTO TABLE wellness.importacctype
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
(field2, field3, field4, Field5);

We convert to "|" delimeted files, as for most of the fields contain a ",".

Can script a progress.p to extract the data into a "|" delimited file, and import into mysql