It is ages since i wrote this bit :) and this code works good on progress 8. Not sure if this would work in openedge. Will require customization in terms of database name, hostname etc.,
Best of luck
/* Purpose: Code to extract data from a given database */
/*...
Hi guys,
Can you let me know on the actual methodology of copying a progress database across to a new server and a new folder. What i had been doing so far is to:
- Copy the Database files to a new server/new location
- proutil db-name -C runcate bi
- Edit the .st file
- prostrct repair...
Thanks for the reply ram. That works.
Just one final thing - how do i use this code to dump all tables from a database - i mean how do i generlize this code.
Thanks in Advance
V
I have a feeling that am bother you a lot Tom :)
** Line 1. Colon followed by white space terminates a statement. (199)
What does that mean? Am getthing error when i execute the code bit on the procedure editor!
Thanks
V
Yes tom that would work :) but i might have to start creating around 200 dummy tables in SQL server before i could load them :) thats a bit of work :) And the dumps that i've extracted so far don't have the column headers in place - thats another thing that has to be sorted out :) Phew - thats a...
Thanks for the reply tom. Ok - back to the beginning - the database in subject is as good as 10 years old and long forgotten. But now the requirement is to do some BI Analysis on this 10 year old stuff. I myself am an oracle pro and this task had come my way as this became the top priority and...
Alrighty, I got one bit of code working and now i could extract data on to text files.
Going a step further, is it possible to create a data dump file using the query tool so that i could just create another database in the latest version of OpenEdge and the port it directly to a SQL server...
Wow, that worked :) Thanks guys - Adding on to what sekar says - 60K makes sense when we have more that 64k rows extracted on to csv format and we require MS Excel to open the file - that wouldn't work. Alright i can live with that - I would be using notepad to look at the data extract...
Sekar,
That doesn't seem to work. If i copy/paste the code snippet you had sent on to the procedure editor and try executing the same, i get the following message as output:
"This version of PROGRESS compiles only encrypted programs. (1086)"
Not sure on how this could be handled ...
By...
Hi guys,
I'm quite new to Progress. I've been assigned a task of extracting data from an application that runs on progress 7.3B (i presume). The licenses in relation to progress database, that i see on the server hosting this application are as follows:
- Network DB Server (7.3B)
- Client...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.