New Version of Access-to-MySQL Can Synchronize Databases

Intelligent Converters released a new version of Access-to-MySQL enhanced with a lot of valuable features: synchronize existing MySQL tables with MS Access data, option to convert partial data using Select-queries, improved merging algorithm and quick launch.

Moscow, Russia, August 19, 2011 --(PR.com)-- Being one of world's leading software vendors in data conversion field, Intelligent Converters constantly works on product improvements. Following this way, the company released a new version of Access-to-MySQL, a program to migrate Microsoft Access databases to MySQL server, with a lot of important enhancements:

* synchronize existing MySQL tables with MS Access data
* option to convert partial data using Select-queries
* improved merging algorithm
* quick launch

This press release gives detailed description of every new valuable feature implemented.

Data Synchronization

Access-to-MySQL implements synchronization as a combination of inserting MS Access records that are missing in MySQL table and updating existing MySQL records with MS Access data. For synchronization purposes, source and destination tables must have identical structures and have primary key or unique index defined. Assume both MS Access and MySQL databases have table "People" defined as below:

Table1
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

And 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

Intelligent merging

Access-to-MySQL implements merging algorithm as follows. If a table has primary key or an unique index, the program inserts into MySQL database only those records whose key/index value does not exist in the destination MySQL table. Otherwise, Access-to-MySQL appends the whole table of contents to the corresponding MySQL table. If the structures of source and destination tables are different, the program transforms each record of the source table so that it conforms to the destination table structure.

Quick Launch

Once conversion settings are stored into a profile, the program can be run in Quick Launch mode. To run the conversion in Quick Launch mode, user just needs to open Windows Explorer and double-click on the profile description (.a2s) file with left mouse button. This will cause Access-to-MySQL wizard to launch conversion loading the necessary settings from the specified profile. Then user will be taken right to the screen with progress of conversion without entering all conversion settings.

For more information visit http://www.convert-in.com/acc2sql_pr.htm. Comments and suggestions are welcome at service@convert-in.com

###
Contact
Intelligent Converters
Oleg Fedorov
+74951102128
www.convert-in.com
ContactContact
Categories