MSSQL-to-MySQL v5.1 can synchronize databases and convert views

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

- synchronize existing MySQL tables with MS SQL data
- option to convert views
- improved merging algorithm
- quick launch

In this press release we would like to give detailed description of every new valuable feature implemented.

Data Synchronization

MSSQL-to-MySQL implements synchronization as combination of insert MS SQL records that are missing in MySQL table and update existing MySQL records with MS SQL data. For synchronization purpose source and destination tables must have identical structures and have primary key or unique index defined. Assume both MS SQL and MySQL databases have table "People" defined as below:

   People(
   ID Integer NOT NULL,
   FName VARCHAR(50),
   LName VARCHAR(50),
   EMail VARCHAR(50),
       Primary Key (ID)
   );

This table has the following contents in MS SQL 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 SQL data to MySQL in "Synchronize" mode MS SQL 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

MSSQL-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, MSSQL-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 you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description (.m2s) file with left mouse button. This will cause MSSQL-to-MySQL wizard to launch conversion loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.

Please visit http://www.convert-in.com/mss2sql_pr.htm for more information about the product.

# # #

About Intelligent Converters

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.