Everyone who intends to move their database from SQL Server to MySQL need to determine if the performance and durability of the system in handling the migration process to minimize the system downtime. Additionally, it is important to make sure that all data and properties has been converted correctly to prevent loss of data or corruption. There is wide variety of software tools to automate MS SQL to MySQL migration on the market. The products can copy all database objects in the source database management system to the target including table structures with all of necessary attributes (default values, null flag, etc), data, indexes, foreign keys and views.
Advanced SQL Server to MySQL database migration tool must provide the following generic capacities:
- High performance of database migration
- Migration of main database objects: tables, data, indexes, constraints and views
- Support of all versions of Microsoft SQL and MySQL including such forks as MariaDB and Percona
- Support of the most popular SAAS platforms such as Azure SQL and Amazon RDS
- Command line support
- Support for Unicode
- User-friendly interface
- Complete install and uninstall support
One of such migration tools with excellent price to quality ratio is the SQL Server to MySQL converter. The vendor of the product is Intelligent Converters, software company specializing on database migration and synchronization for more than 20 years. Their SQL Server to MySQL converter provides all the capabilities listed above.
For those migration tasks where the destination MySQL does not accept direct connections (as a result of the strict security or limitation of virtual hosting), the converter can export the data into MySQL script file. Following this way MS SQL database is exported into the file containing SQL statements to set-up tables with all indexes and constraints and fill all of them with the data. Later the person responsible for migration process can import this file to MySQL server using phpMyAdmin or command line client.
Sometime migration task may require partial data transfer or merging multiple tables into one. SQL Server to MySQL converter can process result of SELECT queries running against SQL Server database for all those migration projects.
If a user must customize table definitions during migration, this software has the capabilities to provide feature generally known as “custom column mapping”. This function enables you to change name, type, default value and NULL-attribute for virtually every column of SQL Server table and also remove particular columns from conversion.
To get more control over the migration and add more customization into the process, SQL Server to MySQL converter allows to specify the engine of tables like MyISAM or InnoDB and charset for text columns in the destination database.
When calculating the conversion performance, it is recommended to evaluate the database volume, complexity of table structures and resources. The standard speed of conversion available from MS SQL to MySQL tool is around 10000 of records per second on a modern system.
Also, the important advantage of the software if converting SQL Server views into MySQL format as ‘CREATE VIEW’ SQL-queries with support for more than 90% of possible syntax patterns including embedded MS SQL functions without direct MySQL equivalents. Note, that SQL Server APPLY operator is not supported in views.