Search results

I've recently gotten out of the Progress world after 10 years, and have gone full time Oracle. My advice, RUN AS FAR AWAY FROM PROGRESS AS YOU CAN!!!!!. It's a horrible database, feature wise, and it is 100% proprietary. If you plan to do anything on an enterprise level, and ever even think you...

Also, I just tested and index rebuild does not detect and remove the duplicates. Does anyone know how to remove these?

My question is not really about the unknown value, but the fact that if a field is not made MANDATORY, and then that field is place on a PRIMARY UNIQUE index, then Progress allows DUPLICATE records to be inserted on a UNIQUE INDEX. My question is, WHY? This does not seem to make sense.

Can anyone help me with an explanation why it appears that the Progress database will allow duplicate records on a table with a Primary-unique index? This is a QAD database (eB2.1 SP3). Below is the index definition. pu pk_det 6 + pk_domain...

I trialed Fathom in house on my servers for 30 days. Also trialed Oracle's Enterprise Manager Grid Control. We bought the Oracle product, which I would recommend. http://www.oracle.com/technology/products/oem/index.html

By the way Tom, because the Progess database has to be taken down to do most maintenance, that forces me to work on weekends, when the cost of a downed production database is has less of an impact on the company. How is this "less effort to take care of"??? Looking forward to your answer!!!:lol:

To answer Tom & BCM, The dataserver is no more of a "layer" for the Progress database than the Oracle database. The 4gl works much in the same way with either database, with some minor exceptions to the coding (ie. case sensitivity). We have been using the dataserver to connect from MFG/Pro on...

You're really loosing me here. What 'work', 'small gain', 'analysis' are you referring to? Something that I posted?

Actually, this is my understanding, but it MAY be wrong. It's actually quite hard determinging this through QAD based on the way they license and charge, and I am actually in the middle the process of this cost breakdown and comarison. Therefore, I should not have posted this cost comparison...

I don't understand you comment.

I'm not sure about that, but I am currently in the process of determing cost of the dataserver. However, last I knew, Progress new license cost was about $2500/user, and Oracle was $800/user. So if the dataserver costs something less than the difference ($1700), then it would be a break even...

YES. 1. True, but reasons are due to DB features again. Example, when you start the DB you can designate which tables are pre-cached into memory. Eample 2, there are many database buffers for different operations, as opposed to only one (-B) in Progress. And many, many more. 2. True, but...

No, we want to take advantage of the Oracle DB. It is QAD's MFG/Pro applicaton, so 4gl is necessary. Dataserver performance is same or better based on tests already performed.

I am posting this in a new thread because I want to give everyone a chance to convince me why I should not choose an Oracle database over Progress database for my application, and I want to find out if there is a reason that I have not thought of, or am not aware of. Assumptions: - I already...

That's the obvious answer, but say I've built the oracle dataserver, and now have it running against an Oracle database, and i've compensated for the different datatypes and other programming considerations in my Progress application and it is fully functional running against an Oracle database...

For one thing, I don't buy into the 'less is more' theory that Tom Bascom seems to be promoting. To me, that is the same thing as people who work harder at avoiding work, instead of just putting that effort into doing the job better. But, opinions are like *******s, everyones got one. I choose...

well, I guess you could refer to it as WYSIWYG, but I think it is quite a bit more, since this is more than web page/content creation. It is a full blown transactional application development tool intended for enterprise level use. (Hmmm .. . . . wonder how much longer developers will be needed...

If you want to try it, go to this link and click "Request A Workspace" and fill ou the registration. when you receive your login info, you can log in and begin creating an app. I created a form and a report in less than 1 minute - with zero code. http://htmldb.oracle.com/pls/otn

It depends on how you do it, since you have literally 1000's of choices in development software for Oracle databases, but one nice one from Oracle is called Application Express Studio. You can create & deploy a web based application, and not even have to write a single line of code. Check it...

I'm not missing any point. The point is - pointing out advantages of Oracle db over Progess db (facts that have been posted), which happens in this forum all the time. Though I do have to say, I don't understand your meaning. If you want to get into this conversation, try being a little less...