Search code examples
databasecsvopenedgeprogress-db

How in the world can you Get a CSV dump of a 10.1b Progress database?


I am trying to get a CSV dump from a Progress / OpenEdge 10.1b database. This was a database for Intergy EHR so the version of openEdge that shipped with the application is run-time only. I can't compile dump scripts or use Data Adminstration tool on the server to export. I've got a raw copy of all the data files / structure files. Can I extract this data with the evaluation kit version 11? Oh.. I've already contacted Progress software to try and buy a full license for 10.1b and they are just giving me the run around. Does anyone know another solution?

Thank You


Solution

  • Short of having a developer client for the program, the options I see are:

    1) Connect to the 10.1B db from your 11.0 eval kit using a TCP connection, then write some code to export table CSV like so:

    FOR EACH table-name NO-LOCK: 
       EXPORT DELIMITER "," table-name.
    END.
    

    2) get someone to write a CSV exporter for your 10.1B system,

    3) dump all your 10.1B data, then load it into an 11.0 DB and then export from that