Entry

How do I regularly exchange data from an Access database to a MySQL database at a remote location?

Dec 2nd, 2004 04:21
Natalia Mokina, http://www.data-conversions.net/ DMSoft Technologies

You can use Access2MySQL software that performs MS Access (mdb) to 
MySQL and MySQL to Access database conversions. It works with remote 
databases. You just need to specify a server name of your remote base 
when utilizing Access2MySQL (by default it is set to “localhost”).
Access2MySQL Features:
- Database synchronization (Sync version)
- Ability to store data into a dump file, PHP script, SQL Access file 
(Pro version)
- Support for OLE Objects
- Opportunity to select ISAM, MYISAM, HEAP, InnoDB, BDB table types
- Ability to choose a particular number of tables to be converted.
- Saving settings into a .sav file to run the program from command line
- Displaying information about conversion process
- Support for AutoIncrement (AutoNumber) fields conversion 
- Support for MS Access Work Groups
- Ability to automate conversion process with built-in Access2MySQL 
Scheduler
There are two programs that can help you with data conversion - 
Access2MySQL Pro and Access2MySQL Sync. You are welcome to view a brief 
comparison overview of these two versions at: http://www.data-
conversions.net/access-to-mysql-sync-pro-comparison.html
You can find more detailed information about our Access2MySQL Product 
line at http://www.data-conversions.net/
You are welcome to evaluate free fully functional copy of Access2MySQL 
Sync for as much as 5 runs. After trial period expiration 5 records of 
each table will be processed.
You can always download the latest version of Access2MySQL Sync from:   
http://www.dmsofttech.com/downloads/Access2MySQL_Sync.zip    
Access2MySQL Pro is available at: 
http://www.dmsofttech.com/downloads/Access2MySQL_Pro.zip