Search results

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 guys - i've got it working finally :) Regards V

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

<< Haven't been able to create a dump file with field labels or names and data in it. Phew :( Any clues? 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...