Progress 8.3 dump to SQL Server 05

N

niksnipe

New Member
I am very new to Progress. I only learned of its existance 3 weeks ago. My problem is we hae a client with Progress 8.3 and no development license, only production. I need to get a daily feed from them which I will pull into a MS SQL Server 2005 database. Can anyone tell me how I might go about this? I am trying to stay away from putting anything on their machine. How does the ODBC connection work to solve this. Can I get the data coming out in XML, or CVS, etc files?

Thanks,
snipe
 
ODBC Connectivity, XML, and CSV all are possible options. But if you are new to Progress Development, CSV should be the ideal choice.

The following code should dump a table in CSV format.

Output To "C:\OUTPUT.CSV".
For Each MyTable No-lock:
Export Delimiter "," Mytable.
End.
Output Close.

You can use OUTPUT.CSV as an input to SQL Server.
You can also use DATA ADMINISTRATION for dumping tables.
 
"No development license" probably precludes coding any sort of custom data extract yourself.

8.3 is older than dirt. XML support was never in 8.3. It did have ODBC but if it isn't already installed and running you may not have the necessary licenses. Plus it's a major pain to configure and get running and it is unlikely that anyone remembers how :blush:

I don't suppose that upgrading to something that was released in this century is on anyone's agenda?
 
Hi Tom,

I don't need to worry about licensing issues in our company. So I am a bit ignorant on this. But now I want to know about licensing issues coz I am planning to sale software developed by me. Can you please help me about where I can find documents on license costs?

As for XML, I am sorry that I failed to mention v8.3 does not support XML. But I have developed XML based application in 9.1D and that works fine.

And recently we've upgraded to OpenEdge and checked that ODBC connectivity is really smooth here. :)
 
The authoritative source for licensing and cost information is your Progress sales person.

In order to sell a Progress based product you will need to become an "application partner". Check Progress.com for the specific contact details in your local area.
 
You must log in or register to reply here.
Back
Top