Everybody who plans to migrate database from SQL Server to MySQL must verify sufficient performance and reliability of the migration process to reduce the system downtime. In addition, it is very important to ensure that all data and properties has been converted properly in order to avoid data loss or corruption. Software market offers number of special tools to automate MS SQL to MySQL conversion. These products can copy all database objects from the source database management system to the target including table structures with all necessary attributes (default values, null flag, etc), data, indexes, foreign keys and views.
High quality SQL Server to MySQL converter must provide some basic features as follows:
- High performance of database migration
- Support of all versions of Microsoft SQL (including Azure SQL) and MySQL
- Support of all modern platforms
- Command line support
- Support for Unicode
- User-friendly interface
- Complete install and uninstall support
One of such migration tools is MS SQL to MySQL converter by Intelligent Converters, software company specializing on database conversion and synchronization since 2001. This database migration tool provides all capabilities listed above and also it has more advantages.
When there is no direct connection to destination MySQL (due to security reason or virtual hosting limitation), the program can export the data into SQL script file. Following this way, SQL Server database is exported into local file containing SQL statements to create tables with all indexes and constraints and fill them with the data. Later the database administrator or another related person can import this file to MySQL server using the standard tools like phpMyAdmin or command line client.
Particular migration projects may require copying of partial data from or merge multiple tables into a single one. MSSQL to MySQL converter can process result of SELECT queries running against SQL Server database for those migration projects.
If user needs to customize table definitions during migration, the program provides feature known as “custom column mapping”. This feature allows to change name, type, default value and NULL-attribute for any column of SQL Server table as well as remove particular columns from conversion.
In order to make migration process even more flexible, the converter allows to specify MySQL table type (ISAM, MyISAM, HEAP, InnoDB or BDB) and charset for text columns in the destination database.
When estimating the conversion performance, it is important to consider the database volume, complexity of table structures and system resources. The average speed of conversion provided by MS SQL to MySQL tool is approximately 10000 of records per second on a modern system.
Finally, the program convert SQL Server views into MySQL format as ‘CREATE VIEW’ SQL-queries with support for more than 90% of all possible syntax patterns including embedded MS SQL functions having no direct equivalent in MySQL such as: DATEPART, DATENAME, STRING_AGG, TRANSLATE, etc. Note, that SQL Server APPLY operator is not supported in views.