Tuesday, March 20, 2012

Quantify cost of upgrading

Hello all,
I work in an Access 97 environment. While access has filled our needs up to
now, we feel it is best to upgrade. Considering we support the distributio
n needs of roughly 3700 stores across the nation, I'm sure you can agree. H
owever, the corporate gods
that be want us to quantify the decision with a dollar figure. I've been in
this business for 6 years and have a CIS degree from DeVry university and I
have never seen, heard of, or been taught any way to quantify an upgrade of
this scale. Can anyone he
lp me out?Figure out how you are going to develop, access front end, sql backend, or
vb or .net. Based on that get the hardware and software costs. Those are
the easy part, the migration costs, development costs and others will be the
fuzzies.
"dds110" <anonymous@.discussions.microsoft.com> wrote in message
news:9C449569-F660-46B9-A291-3DE46C7C1E4F@.microsoft.com...
> Hello all,
> I work in an Access 97 environment. While access has filled our needs up
to now, we feel it is best to upgrade. Considering we support the
distribution needs of roughly 3700 stores across the nation, I'm sure you
can agree. However, the corporate gods that be want us to quantify the
decision with a dollar figure. I've been in this business for 6 years and
have a CIS degree from DeVry university and I have never seen, heard of, or
been taught any way to quantify an upgrade of this scale. Can anyone help
me out?|||Unfortunately, I think they are looking for how much money we can save.....
...not how much money we will be spending. We've already figured the costs
of most of the required hardware, licensing, etc...
Personally, I think the financial gods that be are stonewalling us by asking
these kinds of questions. The actual savings we will reap are absolutely n
ill, as far as I can see.
We've qualified the necessary upgrade until we're blue in the face. They st
ill want a dollar figure for savings.
Sometimes you win, sometimes you just stay in bed.......|||Get a local Microsoft rep on your side - we work in the education field - th
ey have rep's specifically for that.
If you are buying new hardware - like Dell servers for instance - get a loca
l Dell rep on your side.
The savings will be real - IMHO, ACCESS is really single user - if you are t
he size you indicate, then SQL is your only choice for continued availabilit
y and scalability of a large enterprise systems.
Makes sense to me, anyway. We kept all our customers on dying Digital VAX m
ainframe hardware until SQL 2000 came along...|||Pitch Access not being up to the task. Costs of angered customers, etc.
"dds110" <anonymous@.discussions.microsoft.com> wrote in message
news:00946FF3-A33D-4F7B-A207-8BBB62293D74@.microsoft.com...
> Unfortunately, I think they are looking for how much money we can
save........not how much money we will be spending. We've already figured
the costs of most of the required hardware, licensing, etc...
> Personally, I think the financial gods that be are stonewalling us by
asking these kinds of questions. The actual savings we will reap are
absolutely nill, as far as I can see.
> We've qualified the necessary upgrade until we're blue in the face. They
still want a dollar figure for savings.
> Sometimes you win, sometimes you just stay in bed.......|||Given what you say:

> The actual savings we will reap are absolutely nill, as far as I can see.
Then there's absolutely no reason to upgrade. None. Period.|||I would revisit the statement "We feel it is best to upgrade", and ensure
that the 'feelings' are backed up with facts...
If the Access databases are performing well, perhaps you do not need to
upgrade... If you are getting close to the limits of the capabilities of
Access or the number of concurrent users is stressing the database to the
point you are getting failures, justification might be based on downtime
costs, lost revenues, etc.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"dds110" <anonymous@.discussions.microsoft.com> wrote in message
news:9C449569-F660-46B9-A291-3DE46C7C1E4F@.microsoft.com...
> Hello all,
> I work in an Access 97 environment. While access has filled our needs up
to now, we feel it is best to upgrade. Considering we support the
distribution needs of roughly 3700 stores across the nation, I'm sure you
can agree. However, the corporate gods that be want us to quantify the
decision with a dollar figure. I've been in this business for 6 years and
have a CIS degree from DeVry university and I have never seen, heard of, or
been taught any way to quantify an upgrade of this scale. Can anyone help
me out?|||> > The actual savings we will reap are absolutely nill, as far as I can
see.
I missed that. The Sarge is right then. Microsoft probably wishes you
would upgrade, but then they don't make you money.
"Sgt. Sausage" <nobody@.nowhere.com> wrote in message
news:40637516$0$73080$a0465688@.nnrp.fuse.net...
> Given what you say:
>
see.
> Then there's absolutely no reason to upgrade. None. Period.
>
>

No comments:

Post a Comment