Verify that the max_allowed_packet option in the MySQL server is sufficient for the largest field to be migrated.Įnsure that we can connect to both destination MySQL server database, and source MsSQL Server database with appropriate privileges that are required for migrating the data across. Take care of Prerequisitesīefore starting the MySQL database migration wizard in Workbench, we need to ensure that ODBC drivers are present for connecting to the source Microsoft SQL Server database, as it is not bundled with Workbench. The following is an overview of the steps involved in the migration of MsSql database to MySQL using Workbench migration wizard. The most easiest way to install MySQL Workbench is to install “Oracle MySQL installer for windows”, which installs several MySQL tools including the Workbench.ĭownload and install this MySQL Installer, which includes Workbench and other necessary connectors and drivers required for the migration. We can migrate MS SQL database to MySQL using migration module of “MySQL Workbench” utility.

To take advantage of several advanced features of MySQL database that have been tested intensively over the years by a huge open source community.

To implement a highly scalable database infrastructure.

Unlike SQL Server, MySQL supports wide range of Operating Systems including several Linux distros, Solaris and Mac.

In MySQL, even if you decide to use the MySQL enterprise edition, it is less expensive.

To avoid huge License and support fees of MS SQL Server.

The following are few reasons why you might want to consider migrating Microsoft SQL Server to MySQL database: If you are using mostly open source in your enterprise, and have few MS SQL server database around, you might want to consider migrating those to MySQL database.

Tools to help install mysql on mac