I agree with everything that Vic said. But being antiquated isn't always a bad thing. I remember a saying back in the old days when RISC (reduced instruction set chip) CPUs where competing against the more complex CPUs like the Intel chip. The saying was "The RISC chip is like a car that can only make left turns, but it can make three left turns fast then the complex chip can make one right turn".
Â
BTW, I was an early FoxPro fan. I morned when Microsoft bought them.
________________________________
From: Vic Drecchio <
vic.drecchio@...>
To:
vantage@yahoogroups.com
Sent: Mon, May 3, 2010 9:04:38 AM
Subject: RE: [Vantage] Epicor 9 - SQL or Progress
Â
I think about 70%+ of us on here are pro-SQL. But, if you are fluent in
Progress, I'm told (not sure if true) you can do everything in Progress
that you can in MSSQL.
Personally I loathe Progress. It seems so antiquated, limited and
unfriendly. FoxPro has more capability than Progress (IMHO).
There's always the argument that you can run Progress faster on an
equally equipped box. Well, hardware is so cheap these days that
argument doesn't go far with me.
I run SQL and there are countless examples of me being able to do
something in SQL that I couldn't from the Vantage UI or 4GL back-end.
- Triggers (instead of BAMs) - remember, you cannot do a BAM on every
table; triggers you can.
- Triggers (instead of UI customizations) - How many hours have we
wasted trying to put a value into another table/field with embedded
customizations?
- SQL Jobs that run stored procedures
- Complex SQL views that cannot be done with a BAQ pumped to the user
with Crystal Reports or ASP web pages (very slick)
- BI instead of Corvu - run very complex queries and dump results to
dynamic tables for querying by ASP
- I've created web UI's around the Vantage tables that safely add,
delete and modify data
Remember, when you hit the tables with ASP to SQL you circumvent Vantage
licensing. Which means if you have a hallway of Execs that just like to
view colorful dashboards and data then don't worry about installing the
Vantage client on their PC. Internet Explorer is all they need.
Allegedly, I've been told that you can do all of what I say above in
Progress. I feel comfortable restarting the Appservers in Progress and
that's about it. The rest just looks so convoluted and dinosaur to me.
One final note: Since you are one of the few competent Progress users,
don't let that attribute be your only decision-maker. Think of your
company or people that you will hire to help you. SQL folks are a dime
a dozen and quick to locate. Progress is a difficult talent to find.
And when you do, oftentimes it's someone who's been in the industry for
a while and commands a larger compensation package.
Good luck.
____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of hoomail4me
Sent: Saturday, May 01, 2010 10:34 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Epicor 9 - SQL or Progress
Hi All,
Have not been on in quite a while so bear with me if I am asking a
question that have been re-hashed over and over. I would appreciate any
insight or direction to the proper thread...
Looking for recommendations or concerns on implementing Epicor 9 on SQL
or Progress. In my past life I managed Vantage 8 on OpenEdge 10. I lean
towards Progres because of my 4GL background and ease of administration.
Thanks...
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]