MSSQL-to-MySQL

MSSQL-to-MySQL is a program to migrate Microsoft SQL databases to MySQL server. Depending on your privileges on the target MySQL server you can export MS SQL data into new database or overwrite the contents of an existing MySQL database.

Features

• Migrates Microsoft SQL databases to MySQL server directly or into a local MySQL dump file
• Option to convert partial data using SELECT-queries
• Option to synchronize existing MySQL tables with MS SQL data
• Option to customize field mapping (modify name, type, default values for every database column)
• Command line support allows to script, automate and schedule the conversion process
• Converts indexes with all necessary attributes and relationships between tables
• Convert MS SQL views into MySQL format
• Stores conversion settings into profile
• Supports multibyte character sets
• All versions of Windows and Unix/Linux MySQL are supported
• All versions of Microsoft SQL are supported starting from 7.0

What is new in this release:

Version 6.1 allows to customize field mapping (modify name, type, default values for every database column being converted)

Requirements:

Microsoft SQL environment (client or server of MS SQL must be installed in the same machine)

Limitations:

5-record per table limit