On 28 Jul 2004 08:39:32 -0700,
ha********@aol.com (Hank Reed) wrote:
SQL Server can run on any hardware from a $400 Pocket PC (and I'm not
kidding) to a $50,000 and up big server.
The question is, do you need to upgrade? Tell us a bit more about your
situation. How many users, and I mean concurrent users, what are they
doing (read or read/write), and what is the skill level of the person
(perhaps you) who put this db together. Perhaps adding a few indexes
and removing a bunch of DLookups would do the trick.
If you go to SQL Server, don't get trapped by the marketing propaganda
which would make you think it's a simple upgrade using that cool
upgrade wizard already available in Access. The way I see it, there
are two ways to upgrade:
(1) Use the upgrade wizard to move your tables to SQL Server, attach
the tables to the front-end, and keep everything essentially the same.
Time: 2 hours. Performance benefit: minimal, if any. Ancilliary
benefits: better security options, backup, recoverability.
(2) Bite the bullet and do it right. Use a client/server approach.
Probably use Access ADP because it's optimized for that environment.
Time: days or weeks. Performance benefit: fenomenal in some situations
(getting less data), minimal in others (intensive client-side
operations). Ancilliary benefits: same as above.
-Tom.
We are considering migrating our Access backend to SQL Server or
something similar. I am hearing rumors that our server will have to
be a really expensive, beefed-up version. Can anyone shed some light
on that?
Thanks,
Hank Reed