Converting Progress 2

[bs11]

Hello
I am new to this process. We have been given a system called MR2000, which is a medical electronic record, originally marketed by 3M and now abandoned by everyone. It runs on a Progress database which we do not support. Can anyone give me some lead on what is a simple and feasible solution to convert this Progress database into someting easier to handle (like Access?). Or should we consider something like Crystal to move the data somewhere else? Does anyone know who does this kind of stuff? The information in the database is for archival and medico-legal purposes only and has no current use.
Thanks.
bs11

 

[tvrtko]

Try this:

First of all go to control panel, administrative tools, data sources and create ODBC data source that will represent your new database, choose driver you want (for instance MS Access ) and name it (name must not contain spaces etc.). Then create new database (Create Button) that is linked to the new data source. DB name must be different then data source's.

Open the Progress Data Administration Tool and connect to your Progress database. Connection must be local. Choose Data Server, ODBC Utilities, Schema Migration Tools, Progress DB to ODBC. Populate neccessary fields:

Name of Schema Holder DB - name of new db
ODBC Data Source - name of ds
Foreign DBMS Type - MS Access or something
Codepage for Schema image - default is ibm850

Check toggle box "Load SQL" to execute the .sql file that contains the data definition for your Progress database and load these definitions into the target data source.
Uncheck this toggle box to generate only the SQL script.

Check "Move data" toggle box to dump and load data from the Progress database to the target database.

Be aware that Progress supports more fields per table, longer fields and index names etc. then Access.

Good luck

 

[Superfreak3]

I have what I think may be a Progress database that I need converted to Access. Is there any way I can find the Progress software you mention (Progress Data Administration Tool)?

 

[tvrtko]

Data Administration Tool comes with Progress instalation.

 

[Superfreak3]

Is that Progress v9?

 

[Superfreak3]

Also, is there an evaluation download of the required Progress software that you are aware of?

 

[tvrtko]

Yes, that is Progress v9, but I'm afraid that there's no evaluation download of it.