MSAccess MDB -> mySQL Conversion/Sync

[Stone-D]

I'm more than sure that others on this forum have faced this before. Plus, I'm a complete DB newb outside of Access.

What, in your experiences, is the best way to do this, preferably while maintaining table relationships (if possible)?

What pitfalls, if any, should I watch out for when converting Access queries to, say, Perl DBI with mySQL?

At the moment I'm teaching myself Perl DBI using an Access MDB as a source. It seems to be going very well, especially if I compress the output with gzip. For example, when dumping a query's results with no WHERE clause :

Compressed : 86416 bytes.
Uncompressed : 1796671 bytes.

Quite a difference.
_________________
--
Look, no SIG!

[senshi]

mySql because its fast which is what will give your site the edge over an MSAccess type database which are generally very slow especially when you get allot of accounds or data to look up.