MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Articles How To How to: convert or migrate Access to MySQL

How to: convert or migrate Access to MySQL

User Rating: / 225
PoorBest 

Have a Access database about 50 tables, you must convert them to MySQL, how to do this? By what means?

To migrate from an Access database to MySQL we will be using a good program called DBSync. DBSync has a feature that allows us to directly import data from Access databases.

 

 

Here's how to convert Access data to MySQL:

Convert databases from MS Access to MySQL rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed!

 

Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! DBConvert for Access to MySQL is also applicable for MySQL database migration to another MySQL database or to MySQL server.

Moreover, DBConvert for Access to MySQL is quite well for copying MS Access database to another MS Access database.

Features:

  • Access queries conversion support;
  • Interactive (GUI) mode / command line mode;
  • Saving data into a MySQL Dump and PHP script for export to MySQL database;
  • Support for MS Access Work Groups;
  • Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
  • Automation of the conversion process with task scheduler;
  • Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL or MySQL Dump;
  • Unicode Support/Connection character sets support:
    LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, TIS620, UTF8 (unicode charset);
  • Primary keys and Indexes support ;
  • Foreign keys (relations) support;
  • Advanced customization options:
    - partial selection for database objects to be converted;
    - database objects (tables, fields, indexes, foreign keys) tuning up before conversion;
    - detection of possible conversion errors on customization stage.
  • Sessions support - all your settings can be saved and restored later;
  • `ENUM` and `SET` MySQL database types support;
  • `GUID` Access database type support;
  • `OLE Object` packages support;
  • Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
  • Skins support;
  • Multilanguage Support (English, French, Russian, German, Spanish, Italian, Greek and Danish);
  • 1-year free upgrades.
  • Office 2010 support
DOWNLOAD

 

Add comment


Security code
Refresh

mysql tools