Geek asks and answers

How in the world can you get a CSV dump of the progress database 10.1b?

I am trying to get a CSV dump from a Progress / OpenEdge 10.1b database. This was the database for Intergy EHR, so the version of openEdge that ships with the application is only runtime. I cannot compile dump scripts or use the Data Adminstration tool on the server for export. I have a raw copy of all data files / structure files. Can I extract this data using the version 11 evaluation kit? Oh .. I already contacted the Progress software to try and buy the full 10.1b license, and they just give me a run. Does anyone know a different solution?

thank

+3
source share
3 answers

, , , :

1) 10.1B db 11.0 eval, TCP-, CSV :

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

2) - CSV 10.1B,

3) 10.1B, 11.0

+1

, (Admin → Export Data → Text..). - . .

-rx -rq client connection . .

+1

I would use the provided sqldump utility for this. It will upload the table you want directly into the CSV file with the suffix .dsql. It works on all platforms. The table parameter works with wildcards, so you can immediately unload all tables (change PUB.ABCCode to PUB.% In the example below.

In my testing, this is 80% faster than using the EXPORT command in 4GL code.

c:\program files\epicor\>sqldump -u XXXX -a XXXX -t PUB.ABCCode progress:T:l

ocalhost: 9450: mfgsys

OpenEdge Release 10.2A0329  as of Thu Apr 19 10:02:30 EDT 2012

Table      : PUB.ABCCode
Dump file  : PUB.ABCCode.dsql

Dumped 10 Records, 1647 bytes, 1 seconds.

Dumped 1 Tables

c:\program files\epicor\>
+1
source

More articles:


All Articles