If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Other > Extract Data from Progress 4 database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-13-03, 04:38
neilfox neilfox is offline
Registered User
 
Join Date: Mar 2003
Posts: 3
Extract Data from Progress 4 database

Hi,

I am not familiar with Progress at all, however I have been tasked with extracting data from a Progress 4 database into an Access database.

Now reading the posts here there do not appear to be many tools available to perform this function.

The version of Progress we are using is the DOS version 4. I have tried to use the export to DIF format files, however with the limitations within DOS, I can only get very small chunks of data out at a time. The database we are using has been in place since about 1992.

Can anyone give me any ideas as to what I can do to get this information out into Access?

Thanks in advance,

Neil
Reply With Quote
  #2 (permalink)  
Old 04-30-03, 23:51
ProgressDBA ProgressDBA is offline
Registered User
 
Join Date: Apr 2003
Location: Ottawa, Canada
Posts: 14
Is this still an issue for you? If so I may be able to help.
Reply With Quote
  #3 (permalink)  
Old 05-02-03, 11:24
neilfox neilfox is offline
Registered User
 
Join Date: Mar 2003
Posts: 3
Progres Conversion

Hi,

Thanks for the reply.

Yes, we still have a problem, what suggestion do you have?

I look forward to hearing from you.

Neil
Reply With Quote
  #4 (permalink)  
Old 05-02-03, 17:57
ProgressDBA ProgressDBA is offline
Registered User
 
Join Date: Apr 2003
Location: Ottawa, Canada
Posts: 14
Question Re: Progres Conversion

Quote:
Originally posted by neilfox
Hi,

Thanks for the reply.

Yes, we still have a problem, what suggestion do you have?

I look forward to hearing from you.

Neil
Some Questions:

How big is your database? The Database file is the one with a .db extension.

Progress comes in three "flavours": Run-time, Run-Query, and Development. Which flavour do you have? If you are not sure, look in the DLC directory for a file called version. This will tell you.

What format do you want the data in? ASCII File, comma seperated?

Do you need all the tables dumped, or just some of them?

Does the sequence of records with the dump matter to you?
Reply With Quote
  #5 (permalink)  
Old 05-06-03, 04:20
neilfox neilfox is offline
Registered User
 
Join Date: Mar 2003
Posts: 3
Re: Progress Conversion

Thanks for getting back, below are the answers to your questions.

How big is your database? The Database file is the one with a .db extension.
21,263KB

Progress comes in three "flavours": Run-time, Run-Query, and Development. Which flavour do you have? If you are not sure, look in the DLC directory for a file called version. This will tell you.
The content of the VERSION file is: PROGRESS version 5.2I as of Thu FEB 22 1990.

What format do you want the data in? ASCII File, comma seperated?
CSV

Do you need all the tables dumped, or just some of them?
YES

Does the sequence of records with the dump matter to you?
The tables are keyed, therefore the sequence should not cause a problem.

Thanks for you help so far, I look forward to hearing from you in the future.

Neil
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On