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:
- 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?
- 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 Thu Aug 22 2002 - 17:06:11 CDT
