|
Access-to-MySQL is a powerful and reliable tool to migrate Microsoft Access databases to MySQL
server. The program has high performance due to direct connection to source and destination
databases (it does not use ODBC or any other middleware software). Command line support allows
to script, automate and schedule the conversion process.
|
Features
- All versions of MS Access (including MS Access 2010) are supported
- All versions of Unix and Windows MySQL servers are supported
- Special approach for Virtual Server users
- Converts indexes with all necessary attributes
- Converts relationships between tables
- Converts MS Access queries into MySQL views
- Option to convert individual tables
- Option to convert partial data using SELECT-queries
- Stores conversion settings into profile
- Option to merge MS Access data into an existing MySQL database
- Option to synchronize MySQL database with MS Access data
- Handles password protected MS Access databases
- Handles MS Access databases protected with user-level security
- Support for multibyte character sets
- Option to export MS Access data into MySQL dump file
- Command line support
- Quick Launch
- Easy-to-use wizard-style interface
- Full install/uninstall support
- Unlimited 24/7 support service
- 1-year subscription for updates
Limitations
- Does not convert forms, reports and Visual Basic scripts
- Does not convert system (hidden) tables
- Demo version converts only 5 records per table
- Demo version does not convert queries/views and relationships between tables
Requirements
- MS Access installation
- Necessary privileges to write into the destination database
|
|
|
Download trial version
of Access-to-MySQL
Virtual Server users option
- ask your Virtual Server administrator to create blank database for
you
- run Access-to-MySQL and select this database as the conversion
target
- click "Yes" when you will be asked if you'd like to overwrite
existing MySQL database
When you complete these steps, the entire contents of source MS Access database will be imported
into the specified MySQL database.
Thank you for the amazing tool! I was struggling with ODBC and
manually exporting my table. This wonderful utility makes it easy
for me to schedule a Win7 task to do this, as often as it needs
to be done.
John L. Dove
Business Management Research Associates, Inc.
MySQL dump file
Quick Lauch
I purchased your product a couple of weeks ago because I was experience many
problems with my ASP/Access hosted sites with GoDaddy. I used your product
to convert my access databases to MySql and and transferred the data to
awaiting databases on the server. Everything went perfect!!! Your product
saved me an unimaginable amount of time and headaches. I since have been
posting in the help desk forums at GoDaddy and every chance I get I refer
your product. Thank You Very Much.
David Reed
SydCom Computer & Internet, Longview, Texas
Synchronization
People(
ID Integer NOT NULL,
FName Text(50)/VARCHAR(50),
LName Text(50)/VARCHAR(50),
EMail Text(50)/VARCHAR(50),
Primary Key (ID)
);
This table has the following contents in MS Access database:
2 Andrew White a.white@corporation.com
3 Phil Johnson p.johnson@gmail.com
In MySQL database:
1 John Smith j.smith@msn.com
2 Andrew White a.white@yahoo.com
After migrating MS Access data to MySQL in "Synchronize"
mode MS Access table is kept untouched and MySQL table is modified as:
1 John Smith j.smith@msn.com
2 Andrew White a.white@corporation.com
3 Phil Johnson p.johnson@gmail.com
I've been using Intelligent Converters products for years, and they've
saved me many hours of work converting data clients send me. Recently I was having
trouble importing MS Access database with Vietnamese characters, so I emailed
their technical support. They sent me back a suggestion on how to configure
the MySQL settings and now it's working perfectly. Five stars to their tech support!
Tac Tacelosky
Washington, DC
Try before you buy
Download trial version
of Access-to-MySQL
Ordering
|
