Re: is oracle the right tool?

MS-Access would do the job on a nice machine. It's only drawback, regarding your project, is the multi-user business. (.LDB's are weeeeeak.)

2nd choice. MS-Sql. cost is less. learning curve much smaller. MS-Access could easily serve as he front-end (user interface).

"jae" <jae.woo_at_pacificorp.com> 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
Received on Fri Aug 23 2002 - 16:34:36 CDT