Re: Access against Oracle

From: H. John C. Hopkins <john_nospam_at_hpe.ufl.edu>
Date: 1998/02/09
Message-ID: <6bnk2j$bgv@no-names.nerdc.ufl.edu>#1/1

Bob:

30,000,000 eh? Well, you're wise to move up from Access! Is this going to be db heavy with OLTP and/or OLAP? How many users to you have? How much do you want to spend?

To be fair, I have no significant SQL*Server experience, but judging from what I've read, I'd say if your answers to those questions are "yes", "a bunch", and "we have deep pockets", then by all means go with Oracle. If you're not going to be putting heavy stresses on the system, Oracle might still be overkill.

-JCH
>
>I have slight twist to this. I need to choose between Oracle and SQL
>server as an upgrade from Access. Can anyone tell me which might be
>better and why? In the current Access database we are using, we expect to
>receive somewhere around 30,000,000 new records a month. Every thirty
>days the database would be archived. Bob
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Mon Feb 09 1998 - 00:00:00 CST