New version of Access-to-MySQL can synchronize databases

Aug. 18, 2011 - PRLog -- Moscow, Russia - Intelligent Converters released new version (v5.1) of Access-to-MySQL, a program to migrate Microsoft Access databases to MySQL server, with a lot of important enhancements:

(1) synchronize existing MySQL tables with MS Access data;
(2) option to convert partial data using SELECT-queries;
(3) improved merging algorithm;
(4) quick launch

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

Data Synchronization

Access-to-MySQL implements synchronization as combination of insert MS Access records that are missing in MySQL table and update existing MySQL records with MS Access data. For synchronization purpose 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:

   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

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 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 profile, user can run the program in Quick Launch mode: launch 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.

Please visit http://www.convert-in.com/acc2sql_pr.htm for more information.

# # #

Intelligent Converters, one of the world's leading software vendors in data conversion field, entered the software market in 2001. The main goal of our software is to convert data with a minimum loss of information (e.g. formatting properties for text documents or field attributes for databases). Intelligent Converters products are well-known all around the world. There are converters between the most popular databases: Oracle, MySQL, Microsoft Access, Microsoft SQL, IBM DB2 and export tools for Adobe PDF to convert data into Microsoft Word, HTML, plain text, Microsoft Excel and XML. All of them combine ease of use with sufficient capacity to guarantee the best quality of the conversion process.