Epicor 9 and Moving from Progress to MS SQL

Good Day Chris:

I essentially agree that the computer system cannot become your goal, but there are new realities.

I have always told my two IT techs that the purpose of the network was to server the company, not be a IT test bed with all the latest bells and whistles.

However, two things have changed. Every aspect of the company, by way of ERP, is now dependent on the network so it is now more critical to a manufacturer then any Machine tool. Also, Management is demanding more and more: More reports, faster month end closes, more detail - more detail- more detail, Blackberries, handhelds for ERP, Fax-to-email solutions, pretty reports, emails to customers, checks and balances, e-commerce, email blasts, personalized customer communication, etc. It is now IT that has to support the phone system because it is too complex for HR. IT must figure out Long Distance Service because of the T1\ISP\computer interface.

And down time is not allowed. 24/7 because of overseas business units.

So your view, which is also mine, must adapt to the realities of 2010. Unfortunately, many in Upper Management think that all of this is Out-of-the-Box and everybody does it - so they do not perceive a need for bigger IT.

On the other hand, from management's point of view, they have the problem of competing with companies that have stepped up to higher IT Tech which can make the more efficient; but, at the same time see more and more of their assets going to support our glorified adding machines.

Operative ideas:
Change or die.
Modernize or disappear.
Lead or fall behind.
China, not Michigan, is now your competitor.
You have to spend money to make money.
IT spending is the greatest expense, after real estate and people, for most companies now.

Welcome to the brave new world.

len.hartka@...




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, January 18, 2010 8:36 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL




I thnk I may disagree a little here.

98% of our calls logged with support are genuine problems with the Epicor product. Unless we trained up somebody to understand every single working of the product (in which case they would probably uproot and move on to a job where they will get lots mor money).

Unless you are wanting a lot more out of Epicor (by attacking the SQL from the back end - which we dont want), then it is pointless us having 2-3 people with a full understanding of everything that makes Epicor work.

Granted, people need good IT support and infrastructure in place, but at the end of the day our business is doing what we do, not running fixing a computer software. I dont think there is any harm in having people who know what they are doing with servers/PCs/epicor, but a line has to be drawn at some point, before the company changes into an IT company instead of a manufacturing company.

________________________________
From: Vic Drecchio <vic.drecchio@... <mailto:vic.drecchio%40timco.aero> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, 14 January, 2010 17:44:12
Subject: RE: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL


Jared, that's hilarious... and you are so true. You have no idea how
many Vantage customers out there are just like that: With no IT
department.

I find it amusing that a company would spend the significant dollars on
an enterprise IT software system such as Vantage and NOT invest money in
their IT staffing to support and evolve the system.

Frankly, I think that's one of the reasons why Support gets such a
lashing all the time from customers. These non-IT staffed companies
have this belief that Epicor Support is there in lieu of an IT dept or
resource. Epicor Support isn't there to serve in an Admin capacity for
a customer.

It's like buying a mega yacht and not hiring a crew to maintain her.
"Duh"

When I consulted with Epicor I arrived many times at a customer site to
find the server in the breakroom on the counter next to the coffee pot
on the same circuit and it was 80 degrees in the breakroom. Or the
server is out on the shop floor "safely" tucked into a corner somewhere
under a thick coating of shop dust/dirt.

But this ultimately may not be the customers' fault. I think sometimes
Epicor Sales sells Vantage as an entity that requires little or no
admin.

If a customer is very simple in their business model and is small in
user-count, then perhaps you could get away without a staffer. Less
than 10 or 15 users... *maybe*.

It's only the ignorance of the company's management that believes they
can limp along without IT. You buy something like this you should
budget for a resource to provide admin and future enhancements for your
business. Otherwise, if you can't afford to do this, then wait until
you can.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Jared Allmond
Sent: Thursday, January 14, 2010 9:11 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

+1 on everything Vic said. If you have a knowledgeable person, SQL is
great. I met some people at Perspectives 09 whose companies run the
Progress version who don't even have an IT department. A Vantage
'superuser' acts like a sys admin. If you are in this scenario I
wouldn't recommend going to SQL. The ability to make SQL Views is very
useful and speedy compared to BAQs. I personally try to avoid triggers,
but to each his own. You do need plenty of horsepower on a SQL box, and
the name of the game is disk I/O. Don't skimp on your storage system.
I will make a small amendment to Vic's statement that Progress also
runs. Well it does and doesn't. The Progress AppServer still runs (as
it would on either version) but if you configure things properly you
don't need to run the Progress DB (by default it does run). Vic is
correct that the DB is just a pass-thru to the SQL tables.
____________ _________ __
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@wrightcoat ing.com<mailto:jallmond@wrightcoat ing.com>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links

[Non-text portions of this message have been removed]






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
Hello,

Has anyone who has moved from 8.03.4x to Epicor 9 also changed their database from Progress to MS SQL? We are thinking about moving to MS SQL with Epicor 9 and I was just wondering how much of a job it would be to move our data from one database to another.

Thanks,
David Pfiester
NuStep, Inc.
dpfeister@...
We're contemplating the same conversion when we go from Epicor 9.0 to 9.05.

From talking to Epicor people, the conversion can only be done through the Epicor custom service group or whatever they're called.

They also told me the time and cost would depend upon how much data is in our database and how much customization we've added to the system. They typically like to make a few test passes at the database with a copy of the database and then a final go-live conversion.

Can anyone that's done it verify that this is all correct as well.

--- In vantage@yahoogroups.com, "nustepvantage" <dpfiester@...> wrote:
>
> Hello,
>
> Has anyone who has moved from 8.03.4x to Epicor 9 also changed their database from Progress to MS SQL? We are thinking about moving to MS SQL with Epicor 9 and I was just wondering how much of a job it would be to move our data from one database to another.
>
> Thanks,
> David Pfiester
> NuStep, Inc.
> dpfeister@...
>
We reviewed the possibility and choose not to make the move. Review the Epicor literature and preferred/recommended hardware. You will need to invest in several servers to take the place of one Progress box.



Keith





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of nustepvantage
Sent: Wednesday, January 13, 2010 1:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 and Moving from Progress to MS SQL





Hello,

Has anyone who has moved from 8.03.4x to Epicor 9 also changed their database from Progress to MS SQL? We are thinking about moving to MS SQL with Epicor 9 and I was just wondering how much of a job it would be to move our data from one database to another.

Thanks,
David Pfiester
NuStep, Inc.
dpfeister@... <mailto:dpfeister%40nustep.com>





---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
What benefits are there between SQp and Progress?




________________________________
From: Keith Mailloux <keith.mailloux@...>
To: vantage@yahoogroups.com
Sent: Thu, 14 January, 2010 13:17:07
Subject: RE: [Vantage] Epicor 9 and Moving from Progress to MS SQL

Â
We reviewed the possibility and choose not to make the move. Review the Epicor literature and preferred/recommend ed hardware. You will need to invest in several servers to take the place of one Progress box.

Keith

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of nustepvantage
Sent: Wednesday, January 13, 2010 1:42 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Epicor 9 and Moving from Progress to MS SQL

Hello,

Has anyone who has moved from 8.03.4x to Epicor 9 also changed their database from Progress to MS SQL? We are thinking about moving to MS SQL with Epicor 9 and I was just wondering how much of a job it would be to move our data from one database to another.

Thanks,
David Pfiester
NuStep, Inc.
dpfeister@nustep. com <mailto:dpfeister% 40nustep. com>

------------ --------- --------- ---
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
That's an open-ended question, Chris and always sparks a good debate here.

I'm pro-SQL. I have done things with SQL that I couldn't do with Progress.

SQL, IMHO, liberates your data and gives you the freedom to do things easier. Like:

1. Data forensics... easier.. The ability to open tables and view raw data from the server is great. Running adhoc queries to get answers is great.

2. Reporting & BI... SQL Views are my best friend. You want a super complex report? You can do it. I haven't used BAQ's much anymore because they are so basic and limiting and slow. I can have nested subqueries and produce a powerful report with a view and hit that view with ASP and display the results right in Internet Explorer (and VERY quickly). I have a whole intranet set up with various dashboards that our execs don't even need to login to Vantage to see. (save money on licensing and annual maintenance)

3. Customizations.. similar to the BPM functionality, I can create triggers that do things behind the scenes. But since I'm SQL knowledgeable it's tons easier for me to do.

4. Admin... easier. Easy to back up. Easier to copy the LIVE database to PILOT or TEST. Monthly at month-end I copy LIVE to PILOT for our Finance crew to do their ME closing.

I could go on and on. I would never want to regress to Progress.


There are some cons:

You need horsepower on the server. We have a 64 bit box with 16GB of RAM and we run Service Connect, Progress and SQL on it. Performance is great. But you can't skimp on hardware.

You still run Progress even with SQL. Progress acts as a schema holder. Vantage still interacts with the Progress server but Progress simply passes that data thru to SQL.

I wouldn't run Vantage any other way. SQL is great.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Thursday, January 14, 2010 5:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 and Moving from Progress to MS SQL

What benefits are there between SQp and Progress?




________________________________
From: Keith Mailloux <keith.mailloux@...>
To: vantage@yahoogroups.com
Sent: Thu, 14 January, 2010 13:17:07
Subject: RE: [Vantage] Epicor 9 and Moving from Progress to MS SQL

Â
We reviewed the possibility and choose not to make the move. Review the Epicor literature and preferred/recommend ed hardware. You will need to invest in several servers to take the place of one Progress box.

Keith

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of nustepvantage
Sent: Wednesday, January 13, 2010 1:42 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Epicor 9 and Moving from Progress to MS SQL

Hello,

Has anyone who has moved from 8.03.4x to Epicor 9 also changed their database from Progress to MS SQL? We are thinking about moving to MS SQL with Epicor 9 and I was just wondering how much of a job it would be to move our data from one database to another.

Thanks,
David Pfiester
NuStep, Inc.
dpfeister@nustep. com <mailto:dpfeister% 40nustep. com>

------------ --------- --------- ---
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
I agree with everything that Vic said. We did have a few performance
hiccups in the beginning. However, after tweaking our settings,
everything runs ok.



Views are so much better and more powerful than BAQs!!



Thanks,

Sharon





[Non-text portions of this message have been removed]
+1 on everything Vic said. If you have a knowledgeable person, SQL is great. I met some people at Perspectives 09 whose companies run the Progress version who don't even have an IT department. A Vantage 'superuser' acts like a sys admin. If you are in this scenario I wouldn't recommend going to SQL. The ability to make SQL Views is very useful and speedy compared to BAQs. I personally try to avoid triggers, but to each his own. You do need plenty of horsepower on a SQL box, and the name of the game is disk I/O. Don't skimp on your storage system. I will make a small amendment to Vic's statement that Progress also runs. Well it does and doesn't. The Progress AppServer still runs (as it would on either version) but if you configure things properly you don't need to run the Progress DB (by default it does run). Vic is correct that the DB is just a pass-thru to the SQL tables.
_______________________
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@...<mailto:jallmond@...>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007



[Non-text portions of this message have been removed]
Jared, that's hilarious...and you are so true. You have no idea how
many Vantage customers out there are just like that: With no IT
department.

I find it amusing that a company would spend the significant dollars on
an enterprise IT software system such as Vantage and NOT invest money in
their IT staffing to support and evolve the system.

Frankly, I think that's one of the reasons why Support gets such a
lashing all the time from customers. These non-IT staffed companies
have this belief that Epicor Support is there in lieu of an IT dept or
resource. Epicor Support isn't there to serve in an Admin capacity for
a customer.

It's like buying a mega yacht and not hiring a crew to maintain her.
"Duh"

When I consulted with Epicor I arrived many times at a customer site to
find the server in the breakroom on the counter next to the coffee pot
on the same circuit and it was 80 degrees in the breakroom. Or the
server is out on the shop floor "safely" tucked into a corner somewhere
under a thick coating of shop dust/dirt.

But this ultimately may not be the customers' fault. I think sometimes
Epicor Sales sells Vantage as an entity that requires little or no
admin.

If a customer is very simple in their business model and is small in
user-count, then perhaps you could get away without a staffer. Less
than 10 or 15 users... *maybe*.

It's only the ignorance of the company's management that believes they
can limp along without IT. You buy something like this you should
budget for a resource to provide admin and future enhancements for your
business. Otherwise, if you can't afford to do this, then wait until
you can.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jared Allmond
Sent: Thursday, January 14, 2010 9:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

+1 on everything Vic said. If you have a knowledgeable person, SQL is
great. I met some people at Perspectives 09 whose companies run the
Progress version who don't even have an IT department. A Vantage
'superuser' acts like a sys admin. If you are in this scenario I
wouldn't recommend going to SQL. The ability to make SQL Views is very
useful and speedy compared to BAQs. I personally try to avoid triggers,
but to each his own. You do need plenty of horsepower on a SQL box, and
the name of the game is disk I/O. Don't skimp on your storage system.
I will make a small amendment to Vic's statement that Progress also
runs. Well it does and doesn't. The Progress AppServer still runs (as
it would on either version) but if you configure things properly you
don't need to run the Progress DB (by default it does run). Vic is
correct that the DB is just a pass-thru to the SQL tables.
_______________________
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@...<mailto:jallmond@...>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007



[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Good Day Chris:

Sun Is on:
M2K, 7.0 SP7, Informix ( not Unix) (Currently using).
Going to: Epicor 9, 9.05, SQL (live 7/1/2010)

We chose SQL because:
We are not live - the just loaded the Software today - go-live is 7/1/2010 ( maybe 8/1)

1. We think that SQL is more likely to continue to be supported.
2. Since SQL is becoming ubiquitous in the business world, future developments will be available for it that will not be for Progress.
3. Fewer, or no, Multi-Valued fields.
4. Business continuity - SQL has inherent ability to do snap shots of the database so if the system goes down, your recovery data is 30 minutes old, not "Last Night Tapes".
5. SQL does require more hardware, but hardware is cheap - $10,000 for 100 users.
6. SQL might virtualizes easier, and in future have more Tools of various sorts.
7. Epicor might give up on Progress at some point, so SQL is the future.
8. SQL is more amendable to SOA ( service oriented Architecture) then Progress - maybe? Somewhat debatable.
9. SQL administration is more Windows based so is more user friendly for Admins.
10. Big concern is that it can be slow if not configured correctly; but it seems that V8 and now E9 are getting faster and faster. Also, if you go with the right hardware you should be OK.

We ran Manage 2000 (M2K ) as a Progress database and it has been excellent since 2001. We never had a major data corruption - never recovered from tape. I do have some concern that SQL will not be that stable, but it has better recovery tools, and I am not sure if Progress will be as stable in the new world of SOA.
I now have problems using the term "SOA", since we now know, from the Fort Hood terrorist that it stands for "Servant of Allah". He had it on his business card.

The more I have gotten into the implementation the better I feel about the SQL vs Progress choice. But I still worry about stability eventhough many on list server are running just fine.

len.hartka@...
Leonard C. Hartka, IT Director\ERP Manager
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...

www.Sunautomation.com <http://www.sunautomation.com/>




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Thursday, January 14, 2010 8:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 and Moving from Progress to MS SQL




What benefits are there between SQp and Progress?

________________________________
From: Keith Mailloux <keith.mailloux@... <mailto:keith.mailloux%40fergusonperf.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, 14 January, 2010 13:17:07
Subject: RE: [Vantage] Epicor 9 and Moving from Progress to MS SQL


We reviewed the possibility and choose not to make the move. Review the Epicor literature and preferred/recommend ed hardware. You will need to invest in several servers to take the place of one Progress box.

Keith

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of nustepvantage
Sent: Wednesday, January 13, 2010 1:42 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Epicor 9 and Moving from Progress to MS SQL

Hello,

Has anyone who has moved from 8.03.4x to Epicor 9 also changed their database from Progress to MS SQL? We are thinking about moving to MS SQL with Epicor 9 and I was just wondering how much of a job it would be to move our data from one database to another.

Thanks,
David Pfiester
NuStep, Inc.
dpfeister@nustep. com <mailto:dpfeister% 40nustep. com>

------------ --------- --------- ---
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
Ok, just to offer a counterpoint to the SQL Server perspectives:

SQL Server is a dog. It has to connect through not only the OE schema handlers but also through ODBC. Progress uses shared memory. Plan on taking a performance hit if you go to SQL plain and simple.

SQL Server is bloated. Take a look at your services list and you'll find a litany of services running to support SQL Server. Progress utilizes one and only for administration.

SQL Server is a resource hog. Testament to the reason why people are boastful of having a 64 bit servers and tons of additional memory.

SQL Server is a kluge. Free text indexing...ugh.

SQL Server is expensive. Plan on ponying up for the additional license fees if you want to go to SQL Server.

SQL Server is restrictive. Need to run on some really big iron with AIX/HPUX/Solaris....you're SOL with SQL.

SQL Server is awkward. A single three line batch file for a db backup as compared to a goofy diagrammatic maintenance plan.

SQL Server is vulnerable. Google "SQL Server exploits" and take a look at the list. Progress....nada.

The truth is that SQL Server is a wonderful DBMS and has a lot going for it. There is a very large talent pool available to administer it. It integrates very nicely with Microsoft desktop products. It is a functional requirement for several Epicor 9 ancillary modules. It has robust management tools. None of these, however, belays the fact that Epicor 9 was written in and for Progress (OE). SQL Server is an afterthought; an add-on no different than if Epicor had decided to also support Oracle or DB2.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/
On 1/14/2010 1:25 PM, Michael Barry wrote:
>
>
> Ok, just to offer a counterpoint to the SQL Server perspectives:
>
> SQL Server is a dog. It has to connect through not only the OE schema
> handlers but also through ODBC. Progress uses shared memory. Plan on
> taking a performance hit if you go to SQL plain and simple.
>
> SQL Server is bloated. Take a look at your services list and you'll find
> a litany of services running to support SQL Server. Progress utilizes
> one and only for administration.
>
> SQL Server is a resource hog. Testament to the reason why people are
> boastful of having a 64 bit servers and tons of additional memory.
>
> SQL Server is a kluge. Free text indexing...ugh.
>
> SQL Server is expensive. Plan on ponying up for the additional license
> fees if you want to go to SQL Server.
>
> SQL Server is restrictive. Need to run on some really big iron with
> AIX/HPUX/Solaris....you're SOL with SQL.
>
> SQL Server is awkward. A single three line batch file for a db backup as
> compared to a goofy diagrammatic maintenance plan.
>
> SQL Server is vulnerable. Google "SQL Server exploits" and take a look
> at the list. Progress....nada.
>
> The truth is that SQL Server is a wonderful DBMS and has a lot going for
> it. There is a very large talent pool available to administer it. It
> integrates very nicely with Microsoft desktop products. It is a
> functional requirement for several Epicor 9 ancillary modules. It has
> robust management tools. None of these, however, belays the fact that
> Epicor 9 was written in and for Progress (OE). SQL Server is an
> afterthought; an add-on no different than if Epicor had decided to also
> support Oracle or DB2.
>
> Michael

Progress is rock-solid. I've been running Progress on a Linux server for
two years without a reboot and I only did it then to move the server. It
was up close to two years before that.
Hi Vic,
Again, +1 on everything you said. A little too close to home sometimes. You know, I don't think I made the connection at the time, but I think we sat in on Ben Nixon's SQL session at Perspectives (I was in the second front row on the left side of the room).

In that same school of thought, you're talking to the entire IT department at my company. Hilarious I know! Somehow people assume that if it takes electricity and has a blinking light, I magically know everything about it. I just have to shake my head. Good job security I suppose.

I can almost match the breakroom/shop/server room. My office doubles as the server room. I've been here about 8 months now, and when I took over we had 2 servers (Vantage + Exchange). The rackmount Vantage server was sitting on a TV stand in the corner of my office without even a cheap UPS (seriously I'm not making this up), and the Exchange box was a glorified desktop (software RAID 1, single processor P4) sitting next to the TV stand with its cover open. Since then I've added a proper rack and a few new servers. But man, it sounds like I share my office with a Harrier jump jet!

We about a $8-10 million a year company with 80 employees (15 Vantage users), and it's ridiculous to have an IT dept of 1 body. My company's problem is they have never experienced the true pain of a disaster. Someone here must live clean because to my knowledge they've never even had a hard drive failure. That being said Management doesn't understand why I'm asking for capital to build redundancy into the system. Short sighted in my opinion, but what do I know; I'm just the stupid IT guy.

Sorry to get off topic on a tangent but I'm sure there's others out there that share my pain.

Jared
jallmond@...

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Jared, that's hilarious...and you are so true. You have no idea how
> many Vantage customers out there are just like that: With no IT
> department.
>
> I find it amusing that a company would spend the significant dollars on
> an enterprise IT software system such as Vantage and NOT invest money in
> their IT staffing to support and evolve the system.
>
> Frankly, I think that's one of the reasons why Support gets such a
> lashing all the time from customers. These non-IT staffed companies
> have this belief that Epicor Support is there in lieu of an IT dept or
> resource. Epicor Support isn't there to serve in an Admin capacity for
> a customer.
>
> It's like buying a mega yacht and not hiring a crew to maintain her.
> "Duh"
>
> When I consulted with Epicor I arrived many times at a customer site to
> find the server in the breakroom on the counter next to the coffee pot
> on the same circuit and it was 80 degrees in the breakroom. Or the
> server is out on the shop floor "safely" tucked into a corner somewhere
> under a thick coating of shop dust/dirt.
>
> But this ultimately may not be the customers' fault. I think sometimes
> Epicor Sales sells Vantage as an entity that requires little or no
> admin.
>
> If a customer is very simple in their business model and is small in
> user-count, then perhaps you could get away without a staffer. Less
> than 10 or 15 users... *maybe*.
>
> It's only the ignorance of the company's management that believes they
> can limp along without IT. You buy something like this you should
> budget for a resource to provide admin and future enhancements for your
> business. Otherwise, if you can't afford to do this, then wait until
> you can.
A little off the OP topic too but while I totally sympathize with Jared on the "one man" IT dept. issue I have to say that from informal benchmarking and conversations at past Perspectives it is a lot more common than many people realize. Especially if someone has come from a very large company it can seem strange. Companies in the $8-10M range often have no dedicated IT staff and there is a large number of Controllers and Finance-VPs in this group who double as IT. At that size a dedicated person is somewhat of a luxury, as bizarre as it seems. I like the comment about electricity and blinking lights though...for the first five years where I am I was designated to put the lights on the Christmas tree - for exactly that reason.

We're a $25-30M company with 33 full users and 19 DC and I'm the only lonely IT person. In manufacturing it goes with the territory although for the past 10 years I've been lobbying for an assistant without success. Probably never happen unless we open a second site. Only blessing is that because I've been here that long the trust factor is raised high enough to get those "needful" things like UPS, backup tape drives and adequate redundancy to prevent disasters, as much as possible. One big downside now is that by our dropping Epicor Support it adds on a whole 'nother dimension of risk

Back on topic a bit I don't think our particular one man shop scenario would be sustainable without using Progress as the DB. It really is rock solid and almost zero attention required. For that matter migrating beyond 6.10 would have been a back breaker too, hence the permanent freeze and dropping support. I would call it job security but learned long ago there is no such thing anymore. I just add as much value as I can and hope it gets noticed.

-Todd C.



________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of k99ja04
Sent: Thursday, January 14, 2010 3:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL



Hi Vic,
Again, +1 on everything you said. A little too close to home sometimes. You know, I don't think I made the connection at the time, but I think we sat in on Ben Nixon's SQL session at Perspectives (I was in the second front row on the left side of the room).

In that same school of thought, you're talking to the entire IT department at my company. Hilarious I know! Somehow people assume that if it takes electricity and has a blinking light, I magically know everything about it. I just have to shake my head. Good job security I suppose.

I can almost match the breakroom/shop/server room. My office doubles as the server room. I've been here about 8 months now, and when I took over we had 2 servers (Vantage + Exchange). The rackmount Vantage server was sitting on a TV stand in the corner of my office without even a cheap UPS (seriously I'm not making this up), and the Exchange box was a glorified desktop (software RAID 1, single processor P4) sitting next to the TV stand with its cover open. Since then I've added a proper rack and a few new servers. But man, it sounds like I share my office with a Harrier jump jet!

We about a $8-10 million a year company with 80 employees (15 Vantage users), and it's ridiculous to have an IT dept of 1 body. My company's problem is they have never experienced the true pain of a disaster. Someone here must live clean because to my knowledge they've never even had a hard drive failure. That being said Management doesn't understand why I'm asking for capital to build redundancy into the system. Short sighted in my opinion, but what do I know; I'm just the stupid IT guy.

Sorry to get off topic on a tangent but I'm sure there's others out there that share my pain.

Jared
jallmond@...<mailto:jallmond%40wrightcoating.com>



[Non-text portions of this message have been removed]
Is SQL faster than Progress for general use (ie loading screens, preparing print data etc etc)?

We aren't interested in seeing any additional info as we can see everything we want to very easily with BAQs and Dashboards. We are firm believers of not getting 'paralysis by analysis'.

Thanks,


CHRIS




________________________________
From: Jared Allmond <jallmond@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thu, 14 January, 2010 17:11:10
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

Â
+1 on everything Vic said. If you have a knowledgeable person, SQL is great. I met some people at Perspectives 09 whose companies run the Progress version who don't even have an IT department. A Vantage 'superuser' acts like a sys admin. If you are in this scenario I wouldn't recommend going to SQL. The ability to make SQL Views is very useful and speedy compared to BAQs. I personally try to avoid triggers, but to each his own. You do need plenty of horsepower on a SQL box, and the name of the game is disk I/O. Don't skimp on your storage system. I will make a small amendment to Vic's statement that Progress also runs. Well it does and doesn't. The Progress AppServer still runs (as it would on either version) but if you configure things properly you don't need to run the Progress DB (by default it does run). Vic is correct that the DB is just a pass-thru to the SQL tables.
____________ _________ __
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@wrightcoat ing.com<mailto:jallmond@wrightcoat ing.com>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
I thnk I may disagree a little here.

98% of our calls logged with support are genuine problems with the Epicor product. Unless we trained up somebody to understand every single working of the product (in which case they would probably uproot and move on to a job where they will get lots mor money).

Unless you are wanting a lot more out of Epicor (by attacking the SQL from the back end - which we dont want), then it is pointless us having 2-3 people with a full understanding of everything that makes Epicor work.

Granted, people need good IT support and infrastructure in place, but at the end of the day our business is doing what we do, not running fixing a computer software. I dont think there is any harm in having people who know what they are doing with servers/PCs/epicor, but a line has to be drawn at some point, before the company changes into an IT company instead of a manufacturing company.




________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Thu, 14 January, 2010 17:44:12
Subject: RE: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

Â
Jared, that's hilarious... and you are so true. You have no idea how
many Vantage customers out there are just like that: With no IT
department.

I find it amusing that a company would spend the significant dollars on
an enterprise IT software system such as Vantage and NOT invest money in
their IT staffing to support and evolve the system.

Frankly, I think that's one of the reasons why Support gets such a
lashing all the time from customers. These non-IT staffed companies
have this belief that Epicor Support is there in lieu of an IT dept or
resource. Epicor Support isn't there to serve in an Admin capacity for
a customer.

It's like buying a mega yacht and not hiring a crew to maintain her.
"Duh"

When I consulted with Epicor I arrived many times at a customer site to
find the server in the breakroom on the counter next to the coffee pot
on the same circuit and it was 80 degrees in the breakroom. Or the
server is out on the shop floor "safely" tucked into a corner somewhere
under a thick coating of shop dust/dirt.

But this ultimately may not be the customers' fault. I think sometimes
Epicor Sales sells Vantage as an entity that requires little or no
admin.

If a customer is very simple in their business model and is small in
user-count, then perhaps you could get away without a staffer. Less
than 10 or 15 users... *maybe*.

It's only the ignorance of the company's management that believes they
can limp along without IT. You buy something like this you should
budget for a resource to provide admin and future enhancements for your
business. Otherwise, if you can't afford to do this, then wait until
you can.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Jared Allmond
Sent: Thursday, January 14, 2010 9:11 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

+1 on everything Vic said. If you have a knowledgeable person, SQL is
great. I met some people at Perspectives 09 whose companies run the
Progress version who don't even have an IT department. A Vantage
'superuser' acts like a sys admin. If you are in this scenario I
wouldn't recommend going to SQL. The ability to make SQL Views is very
useful and speedy compared to BAQs. I personally try to avoid triggers,
but to each his own. You do need plenty of horsepower on a SQL box, and
the name of the game is disk I/O. Don't skimp on your storage system.
I will make a small amendment to Vic's statement that Progress also
runs. Well it does and doesn't. The Progress AppServer still runs (as
it would on either version) but if you configure things properly you
don't need to run the Progress DB (by default it does run). Vic is
correct that the DB is just a pass-thru to the SQL tables.
____________ _________ __
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@wrightcoat ing.com<mailto:jallmond@wrightcoat ing.com>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links







[Non-text portions of this message have been removed]
There are no performance benefits with SQL.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, January 18, 2010 8:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

Is SQL faster than Progress for general use (ie loading screens, preparing print data etc etc)?

We aren't interested in seeing any additional info as we can see everything we want to very easily with BAQs and Dashboards. We are firm believers of not getting 'paralysis by analysis'.

Thanks,


CHRIS




________________________________
From: Jared Allmond <jallmond@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thu, 14 January, 2010 17:11:10
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

Â
+1 on everything Vic said. If you have a knowledgeable person, SQL is great. I met some people at Perspectives 09 whose companies run the Progress version who don't even have an IT department. A Vantage 'superuser' acts like a sys admin. If you are in this scenario I wouldn't recommend going to SQL. The ability to make SQL Views is very useful and speedy compared to BAQs. I personally try to avoid triggers, but to each his own. You do need plenty of horsepower on a SQL box, and the name of the game is disk I/O. Don't skimp on your storage system. I will make a small amendment to Vic's statement that Progress also runs. Well it does and doesn't. The Progress AppServer still runs (as it would on either version) but if you configure things properly you don't need to run the Progress DB (by default it does run). Vic is correct that the DB is just a pass-thru to the SQL tables.
____________ _________ __
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@wrightcoat ing.com<mailto:jallmond@wrightcoat ing.com>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Trust me, there are plenty of problems with Epicor and Vantage even with a fully operational IT department. The problems we run into time and again are software related problems. When we installed 8.0 four years ago, we were sold on many functions that simply do not operate as advertised. 8.0 was an unstable environmental and would freeze up and require end-user reboots at least once a day. We migrated to 8.03 and the environment has been much more stable but then we had to operate for four months because the configurator did not function. Epicor finally released a patch to fix the configurator, but with that patch they managed to break something else. This has been on-going with Epicor. We just upgraded to 8.03.408B to try and fix a couple of A/R issues. As usual, the patch did fix the A/R issues, but now the “Get Methods” function of Vantage takes 5-10 MINUTES when it use to take 1-2 SECONDS. Same hardware, same methods, new patch.



Yes I agree that you must have the proper hardware and maintain the hardware in the appropriate environment, but our problems generally relate to the Epicor Software.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, January 18, 2010 7:36 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL





I thnk I may disagree a little here.

98% of our calls logged with support are genuine problems with the Epicor product. Unless we trained up somebody to understand every single working of the product (in which case they would probably uproot and move on to a job where they will get lots mor money).

Unless you are wanting a lot more out of Epicor (by attacking the SQL from the back end - which we dont want), then it is pointless us having 2-3 people with a full understanding of everything that makes Epicor work.

Granted, people need good IT support and infrastructure in place, but at the end of the day our business is doing what we do, not running fixing a computer software. I dont think there is any harm in having people who know what they are doing with servers/PCs/epicor, but a line has to be drawn at some point, before the company changes into an IT company instead of a manufacturing company.

________________________________
From: Vic Drecchio <vic.drecchio@... <mailto:vic.drecchio%40timco.aero> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, 14 January, 2010 17:44:12
Subject: RE: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL


Jared, that's hilarious... and you are so true. You have no idea how
many Vantage customers out there are just like that: With no IT
department.

I find it amusing that a company would spend the significant dollars on
an enterprise IT software system such as Vantage and NOT invest money in
their IT staffing to support and evolve the system.

Frankly, I think that's one of the reasons why Support gets such a
lashing all the time from customers. These non-IT staffed companies
have this belief that Epicor Support is there in lieu of an IT dept or
resource. Epicor Support isn't there to serve in an Admin capacity for
a customer.

It's like buying a mega yacht and not hiring a crew to maintain her.
"Duh"

When I consulted with Epicor I arrived many times at a customer site to
find the server in the breakroom on the counter next to the coffee pot
on the same circuit and it was 80 degrees in the breakroom. Or the
server is out on the shop floor "safely" tucked into a corner somewhere
under a thick coating of shop dust/dirt.

But this ultimately may not be the customers' fault. I think sometimes
Epicor Sales sells Vantage as an entity that requires little or no
admin.

If a customer is very simple in their business model and is small in
user-count, then perhaps you could get away without a staffer. Less
than 10 or 15 users... *maybe*.

It's only the ignorance of the company's management that believes they
can limp along without IT. You buy something like this you should
budget for a resource to provide admin and future enhancements for your
business. Otherwise, if you can't afford to do this, then wait until
you can.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Jared Allmond
Sent: Thursday, January 14, 2010 9:11 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

+1 on everything Vic said. If you have a knowledgeable person, SQL is
great. I met some people at Perspectives 09 whose companies run the
Progress version who don't even have an IT department. A Vantage
'superuser' acts like a sys admin. If you are in this scenario I
wouldn't recommend going to SQL. The ability to make SQL Views is very
useful and speedy compared to BAQs. I personally try to avoid triggers,
but to each his own. You do need plenty of horsepower on a SQL box, and
the name of the game is disk I/O. Don't skimp on your storage system.
I will make a small amendment to Vic's statement that Progress also
runs. Well it does and doesn't. The Progress AppServer still runs (as
it would on either version) but if you configure things properly you
don't need to run the Progress DB (by default it does run). Vic is
correct that the DB is just a pass-thru to the SQL tables.
____________ _________ __
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@wrightcoat ing.com<mailto:jallmond@wrightcoat ing.com>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Chris, if you have ONE person knowledgeable about the technical side of Vantage/Vista then you are better off than probably 80% of the client base out there. Having 2-3 people supporting Epicor is not necessary unless you are a larger customer with 50+ total Epicor users with a thirsty user base in regards to BI while running many complicated modules (IQS, PLM, etc).

I said there are many companies out there without *any* IT staffing internally. Not just support related to Epicor, but IT support, period. No IT dept. The guy working the lathe on the shop floor is the designated quasi-IT department because he replaced a hard drive in his home PC once.

98% of my calls logged with support are legitimate issues with the product, too. But I may call Support on average of once every 5-6 weeks.

There are customers out there that call Support multiple times weekly and attempt to log calls using Vantage/Vista as the scapegoat. Trust me, I've seen it first hand. There are customers out there that have all their users directly call Epicor Support without someone first attempting to resolve the problem internally.

These are some calls Epicor Support receives:

"My computer won't boot today, it freezes before I can even log in to Windows; the last thing I was using was Vantage."

"My computer says I have infected files, what should I do?"

"I need to get this report into Excel, how do I do that?"

"I applied [Microsoft] updates to my computer and now Vantage won't work."

"We had a power outage and the server running Vantage crashed and now users cannot log into Vantage."


Those are examples of things that should be resolved internally with a company's own IT dept. Proper general-IT staffing (at a minimum) is necessary. I never stated that you needed an internal Epicor Support department 3 people deep.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, January 18, 2010 8:36 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

I thnk I may disagree a little here.

98% of our calls logged with support are genuine problems with the Epicor product. Unless we trained up somebody to understand every single working of the product (in which case they would probably uproot and move on to a job where they will get lots mor money).

Unless you are wanting a lot more out of Epicor (by attacking the SQL from the back end - which we dont want), then it is pointless us having 2-3 people with a full understanding of everything that makes Epicor work.

Granted, people need good IT support and infrastructure in place, but at the end of the day our business is doing what we do, not running fixing a computer software. I dont think there is any harm in having people who know what they are doing with servers/PCs/epicor, but a line has to be drawn at some point, before the company changes into an IT company instead of a manufacturing company.




________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Thu, 14 January, 2010 17:44:12
Subject: RE: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

Â
Jared, that's hilarious... and you are so true. You have no idea how
many Vantage customers out there are just like that: With no IT
department.

I find it amusing that a company would spend the significant dollars on
an enterprise IT software system such as Vantage and NOT invest money in
their IT staffing to support and evolve the system.

Frankly, I think that's one of the reasons why Support gets such a
lashing all the time from customers. These non-IT staffed companies
have this belief that Epicor Support is there in lieu of an IT dept or
resource. Epicor Support isn't there to serve in an Admin capacity for
a customer.

It's like buying a mega yacht and not hiring a crew to maintain her.
"Duh"

When I consulted with Epicor I arrived many times at a customer site to
find the server in the breakroom on the counter next to the coffee pot
on the same circuit and it was 80 degrees in the breakroom. Or the
server is out on the shop floor "safely" tucked into a corner somewhere
under a thick coating of shop dust/dirt.

But this ultimately may not be the customers' fault. I think sometimes
Epicor Sales sells Vantage as an entity that requires little or no
admin.

If a customer is very simple in their business model and is small in
user-count, then perhaps you could get away without a staffer. Less
than 10 or 15 users... *maybe*.

It's only the ignorance of the company's management that believes they
can limp along without IT. You buy something like this you should
budget for a resource to provide admin and future enhancements for your
business. Otherwise, if you can't afford to do this, then wait until
you can.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Jared Allmond
Sent: Thursday, January 14, 2010 9:11 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

+1 on everything Vic said. If you have a knowledgeable person, SQL is
great. I met some people at Perspectives 09 whose companies run the
Progress version who don't even have an IT department. A Vantage
'superuser' acts like a sys admin. If you are in this scenario I
wouldn't recommend going to SQL. The ability to make SQL Views is very
useful and speedy compared to BAQs. I personally try to avoid triggers,
but to each his own. You do need plenty of horsepower on a SQL box, and
the name of the game is disk I/O. Don't skimp on your storage system.
I will make a small amendment to Vic's statement that Progress also
runs. Well it does and doesn't. The Progress AppServer still runs (as
it would on either version) but if you configure things properly you
don't need to run the Progress DB (by default it does run). Vic is
correct that the DB is just a pass-thru to the SQL tables.
____________ _________ __
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@wrightcoat ing.com<mailto:jallmond@wrightcoat ing.com>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links







[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
A little known and undocumented change in 408 was the "Get Methods" operation in the Engineering workbench changed from defaulting to getting the method from the configurator to getting the method from the Part Master. This was suppose to speed up the "Get Method", but it really messed us up.

After many complaints from us I got them to agree to change this so that you can specify in the configurator the default for the "Get Method". Never heard a word back from them since then.

After 1 year, the "Verify Existing Configurations" is still broken.




________________________________
From: Andrew Best <abest@...>
To: vantage@yahoogroups.com
Sent: Mon, January 18, 2010 9:22:35 AM
Subject: RE: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

Â
Trust me, there are plenty of problems with Epicor and Vantage even with a fully operational IT department. The problems we run into time and again are software related problems. When we installed 8.0 four years ago, we were sold on many functions that simply do not operate as advertised. 8.0 was an unstable environmental and would freeze up and require end-user reboots at least once a day. We migrated to 8.03 and the environment has been much more stable but then we had to operate for four months because the configurator did not function. Epicor finally released a patch to fix the configurator, but with that patch they managed to break something else. This has been on-going with Epicor. We just upgraded to 8.03.408B to try and fix a couple of A/R issues. As usual, the patch did fix the A/R issues, but now the “Get Methods” function of Vantage takes 5-10 MINUTES when it use to take 1-2 SECONDS. Same hardware, same methods, new patch.



Yes I agree that you must have the proper hardware and maintain the hardware in the appropriate environment, but our problems generally relate to the Epicor Software.



From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Chris Thompson
Sent: Monday, January 18, 2010 7:36 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL





I thnk I may disagree a little here.

98% of our calls logged with support are genuine problems with the Epicor product. Unless we trained up somebody to understand every single working of the product (in which case they would probably uproot and move on to a job where they will get lots mor money).

Unless you are wanting a lot more out of Epicor (by attacking the SQL from the back end - which we dont want), then it is pointless us having 2-3 people with a full understanding of everything that makes Epicor work.

Granted, people need good IT support and infrastructure in place, but at the end of the day our business is doing what we do, not running fixing a computer software. I dont think there is any harm in having people who know what they are doing with servers/PCs/ epicor, but a line has to be drawn at some point, before the company changes into an IT company instead of a manufacturing company.

____________ _________ _________ __
From: Vic Drecchio <vic.drecchio@ timco.aero <mailto:vic. drecchio% 40timco.aero> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Thu, 14 January, 2010 17:44:12
Subject: RE: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL


Jared, that's hilarious... and you are so true. You have no idea how
many Vantage customers out there are just like that: With no IT
department.

I find it amusing that a company would spend the significant dollars on
an enterprise IT software system such as Vantage and NOT invest money in
their IT staffing to support and evolve the system.

Frankly, I think that's one of the reasons why Support gets such a
lashing all the time from customers. These non-IT staffed companies
have this belief that Epicor Support is there in lieu of an IT dept or
resource. Epicor Support isn't there to serve in an Admin capacity for
a customer.

It's like buying a mega yacht and not hiring a crew to maintain her.
"Duh"

When I consulted with Epicor I arrived many times at a customer site to
find the server in the breakroom on the counter next to the coffee pot
on the same circuit and it was 80 degrees in the breakroom. Or the
server is out on the shop floor "safely" tucked into a corner somewhere
under a thick coating of shop dust/dirt.

But this ultimately may not be the customers' fault. I think sometimes
Epicor Sales sells Vantage as an entity that requires little or no
admin.

If a customer is very simple in their business model and is small in
user-count, then perhaps you could get away without a staffer. Less
than 10 or 15 users... *maybe*.

It's only the ignorance of the company's management that believes they
can limp along without IT. You buy something like this you should
budget for a resource to provide admin and future enhancements for your
business. Otherwise, if you can't afford to do this, then wait until
you can.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Jared Allmond
Sent: Thursday, January 14, 2010 9:11 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Epicor 9 and Moving from Progress to MS SQL

+1 on everything Vic said. If you have a knowledgeable person, SQL is
great. I met some people at Perspectives 09 whose companies run the
Progress version who don't even have an IT department. A Vantage
'superuser' acts like a sys admin. If you are in this scenario I
wouldn't recommend going to SQL. The ability to make SQL Views is very
useful and speedy compared to BAQs. I personally try to avoid triggers,
but to each his own. You do need plenty of horsepower on a SQL box, and
the name of the game is disk I/O. Don't skimp on your storage system.
I will make a small amendment to Vic's statement that Progress also
runs. Well it does and doesn't. The Progress AppServer still runs (as
it would on either version) but if you configure things properly you
don't need to run the Progress DB (by default it does run). Vic is
correct that the DB is just a pass-thru to the SQL tables.
____________ _________ __
Jared Allmond
IT Systems Administrator
Wright Coating Technologies
jallmond@wrightcoat ing.com<mailto: jallmond@ wrightcoat ing.com>
voice: 269.344.8195
direct: 269.341.4353
fax: 269.344.3007

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]