I've used all three, Access, Oracle and MySQL. I have the least expertise
with Access.
My impressions are:
* Access is very limited in what it can do with respect to real database
manipulations, those contained in SQL. It does not handle large amounts of
data well. Access is really a very fancy, scriptable (VB) GUI wrapped
around a very simple database engine.
* MySQL is a very fast, efficient fairly well featured database system,
which can handle large amounts of data. It handles most standard SQL
constructs.
* Oracle is a very extensive database system, with many extensions, tools
and features. It handles all standard SQL constructs and adds many
non-standard SQL constructs. It is also a rather large "footprint".
Comparatively, MySQL lacks a number of features that Oracle has: subselects,
views, referential integrity, cluster ability, etc. But for the most part,
MySQL and Oracle are more similar than either is like Access.
I'd guess that for the most part, moving the "small" projects to MySQL from
Access will make future moves from MySQL to Oracle much easier than moving
them from Access to Oracle.
----- Original Message -----
From: "Gene Gurevich" <[EMAIL PROTECTED]>
This is a very generic quesiton and I would appreciate
any info. I am an Oracle dba; our developers are now
using access for their own small projects. When these
projects grow and become too large for Access we move
them to Oracle. The developers are now considering
switching from Access to MySQL and I'm trying to
figure out what are the advantages of that move. I
have read some documentation and it looks like a big
advantage of
MySQL vs Access is multi-user access. There are also
some features that are present in Oracle but missing
in My SQL like views, subqueries and a few other. I
was wondering if someone who has working experience in
both Access and MYSQL (or ORacle and MySQL) could
expand on the differences from practical standpoint.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
