Progress 8.2 export

[craig]

I'm running a Progress v8.2 database on SCO OpenServer 5.0, now I'm looking for some way of exporting the data (even to .csv would do), so I can later put it into a MySQL database on Linux.
I have some experience with SCO but none with Progress so any help would be more than appreciated

thanks,
Craig

 

[StoneKeeper]

export of data

hi,
you have a lot of possibilities to export data - e.g. use the following code in the procedure editor:

/*
define output file
*/
output to value("c:\temp\filename.csv").

/*
export the headline - one for each column - if you want
*/
export "column-desc1" "column-desc2" .

/*
export the recordbuffer
*/
for each tablename no-lock:
export table.
end.


Or use the dump utility.

regards
stonekeeper