Re: is oracle the right tool?

jae.woo_at_pacificorp.com (jae) wrote in message news:<b5905300.0208221406.393de088_at_posting.google.com>...
> I am seeking some advice. I am just starting a project that requires
> a database that will have at least 1 million rows and potentially up
> to 10 to 20 million. There will probably be about 10 tables, that are
> fairly simple with about 10 fields. Total number of users will be
> about 10 also. I was wondering if oracle is the right tool to choose.
> My background is purely MS Access and I'm pretty sure that this is
> too large for MS Access. The extent to which I have used Oracle is to
> connect to it with MS Access using ODBC. I consider myself an expert
> at Access but know next to nothing about Oracle, so my questions are:
>
> 1) Oracle or MS SQL Server? or is Oracle too much for what I'm trying
> to do? I'm leaning towards Oracle because it's not from MS and I have
> the impression that it is better. Not to open any cans of worms but
> am I generally right?
>
> 2) If Oracle, then which of the many bizzillion flavors (8i, 8i
> personal, 9i, 8i enterprise, et al) do I use considering I am
> completely new to this but have a good capacity to teach myself?
>
> any advice on this would be greatly appreciated.
> thx
> Jae

First of all, both MSSQL and Oracle can more then adequately handle this. As the matter of fact, solution to your requirement can be provided by any vendors like Oracle, MSSQL (Except MS Access), DB2, Sybase, Informix etc. The thing you would need to look at is what makes most sense when you do cost/benefit analysis.

RDBMS is a technology and all above mentioned vendors provide tools under that technology. You as a solution provider have to pick the right tool for the right money. Although I work with Oracle and am biased towards it, *but* in your situation, MSSQL will probably make most business sense. Why,

1. MSSQL is cheaper then Oracle and will be able to handle the job.
2. More importantly, you already have MS Access skills and can leverage those towards MSSQL thus reducing the learning curve considerably. (This is your business bottom line).

Having said all of the above... putting 2 years of Oracle experience in your resume will probably open few more doors for you then 2 years of MSSQL.
(This is your personal career bottom line). -:)

//Rauf Sarwar Received on Sat Aug 24 2002 - 00:26:45 CDT