SQL Server

At Perspectives there was a SQL Server session. There were about 5 people
there, and I don't believe any of them were running SQL server. We asked
how many customers were running SQL Server, I believe the Instructor said he
could count them on his hands...



[Non-text portions of this message have been removed]
Hi,
I'm new to the user group but not to Vantage. I was just wondering
if there was any other MS SQL Server users out there. I haven't
really been able to get a good answer from anyone at Epicor.
I'm thinking that I'm the only one.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
Jeremy, I believe that you may indeed be the only SQL user on this list...

My sales rep (northern california) said only one of his clients was
considering the SQL version of vantage, and recommended that we not use it,
because it would be slower and less reliable the Progress version. He did
say though, that support for SQL is improving, but didn't think it was worth
the extra investment in software and hardware at this point.

So no, I'm not using SQL yet, because epicor has recommended that I not, but
I am interested in researching that avenue further.

So which version of vantage are you running?
What are the specs on your server?
Have you been using the SQL version since you started using vantage, or had
you upgraded from a previous release?
Are you linking the vantage SQL database to other data sources?

Well, sorry to bombard you with questions, but you are the Only One.

Regards,

Thaddeus



-----Original Message-----
From: jleonard@... [mailto:jleonard@...]
Sent: Wednesday, November 28, 2001 7:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Server


Hi,
I'm new to the user group but not to Vantage. I was just wondering
if there was any other MS SQL Server users out there. I haven't
really been able to get a good answer from anyone at Epicor.
I'm thinking that I'm the only one.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation




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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Well, this is a long response so print it out and take a coffee break
or something.

We started on Version 4.0 on Progress in Feb of this year. It ran
very fast. We went to Vantage 5.0 and MS SQL Server 7.0 in mid-
June. It was a mistake for us to do both at the same time but we
received conflicting information from Epicor as to the proper upgrade
path. At that time we where running Vantage on an IBM Netfinity
dual PIII 866 with 1GB of Ram and RAID 10. We immediately noticed
about a 60% drop in speed. Some reports, such as the Priority
Dispatch Report, took near an hour to run. Visual scheduling took
nearly 20 hours to run with just a few thousand jobs in our
database. After working with Progress directly I was able to recover
about 20% of the speed. I also rewrote any problem reports in
Crystal and Access. The Priority Dispatch Report now takes about 7
seconds to run every work center in our plant. I was assured by
Progress that 9.1C would have substantial speed increases and support
MS SQL 2000 so we stayed with SQL. Just before the Orlando
Conference I upgrade my server to an HP Netserver LH 6000 with 6
Xeon 550's with 2mb Cache, 8GB of RAM, and Raid 10. We also went to
Vantage 5.1 and MS SQL Server 2000. We seen considerable increases
in speed with the new 9.1C Dataserver product. The hardware helped
some but not as much as the software upgrade. MS SQL 2000 played as
important a role as 9.1C in speed increase. The upgrade itself went
very poorly. The data conversion went fine but the internal setup
of the Progress Dataserver product and the Schema Holder was not as
the Upgrade instructions for Vantage 5.1 SQL Server had stated. In
fact, I just checked them and they are still not correct on the web
site. We where limited to 5 users in Vantage for about 2 days. I
finally called Progress directly and they helped me out. In 9.1a we
ran the VantSH.db schema holder like a normal database. In 9.1C no
Progress database can be running. If you do have one running then
Progress licensing limits you to 5 connections. There were also
substantial changes that needed to be made to the Vantage.vtg files
since we no longer had access to the Data Administration Connections
area of Progress. We also had a big problem with TTY errors that
was helped by applying the 9.1C.10 patch from Progress. The TTY
issues still exist but are very small compared to what we did have.
To be honest, we had so many problems and such a rough time that the
decision to leave Vantage for Great Plains had been made before I
left for the Vantage Conference. At the conference I raised my
concerns to several of the Epicor staff and we had a few meeting. .
After working with Vantage Tech support very closely this month I
would say we are in good shape for the first time since we went to
Vantage 5.0. Epicor has really stepped up to the plate and fixed a
lot of the issues we have had so we decided to stay with Vantage. We
are currently linking our Vantage Database to 13 Access databases.
We also have about the same number of V.B. and Crystal Reports
running of the SQL Database. We are still avoiding altering any data
in the database as to not give Epicor any reason to disallow our Tech
Support. We of course don't want any blame for corrupt data. I've
always like SQL Server and have about 5 years experience with it. We
haven't had any problems at all from the MS SQL side of the
application. I think Epicor almost has the SQL Dataserver problems
figured out. I wouldn't make the move to SQL Server now but I would
consider it a few more patches down the road.

Thanks
Jeremy Leonard
IT Manager
K-T Corporation
jleonard@...
At Perspectives there was a SQL Server session. There were about 5 people
there, and I don't believe any of them were running SQL server. We asked
how his hands...



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