Migrate SQL Server to MySQL via MySQLyog

SQLyog is a robust graphical user interface (GUI) tool designed for managing and developing MySQL and MariaDB databases. It enables database administrators and developers to visually compare, optimize, and document schemas. Bwing developed in C++, SQLyog is available in both a free version (Community Edition on GitHub) and paid versions (Professional, Enterprise, and Ultimate Editions).

SQLyog works on Windows starting from Vista to version 11, Linux, Unix and macOS via Wine.

Key capabilities of the product:

• Import data from any databases that provides ODBC driver
• SQL editor with syntax highlighting and miscellaneous formatting choices
• Connectivity options for different layers such as HTTP/HTTPS or SSH tunneling
• Option to synchronize and visually compare the data
• SQL statements automatic execution
• Tools to find redundant indexes and foreign key lookup
• Visual schema designer
• Query profiler
• Visual query builder

To migrate SQL Server database to MySQL via MySQLyog, take the following steps:

• Right-click the target database, select "Import" > "Import External Data" menu item
• Select "Start a new job" and click "Next"
• If there is no DSN that needs to be exported to SQL Server in your list, select "Create a New DSN". Then choose "File Data Source" and click "Next". Finally, select "SQL Server" as the driver and click "Next".
• Enter a data source file name or browse for its location and click "Next".
• Enter name and description for the data source, select "SQL Server" from the drop-down list and click "Finish".
• If you are connecting the remote server, "choose Use user to enter login ID and password for SQL Server authentication" on the next window and specify user ID and password. Click "Next".
• Select "Change the default database to" box and select one from the drop-down, then select "Use ANSI reference identifier" and "Use the null value, fill-in, and warning of ANSI". Test the data source.
• Select "Type of Data Source" as "Any ODBC Source" and select file DSN being created recently. Specify SQL Server user name and password to log in.
• On the next window choose the destination MySQL server, provide the IP address, and account details. Test the connection.
• Select "Copy table(s) from the data source" and click "Next".
• Choose individual tables or select all to migrate. If some table contains bit type or date (datetime) type, it must be mapped. Otherwise, the migration will fail. Click and edit the corresponding three dots under the "Map", and the tool will change it to the compatible types.
• In the "Advanced" options section select "Import into existing table", "Update with source details", and "Import foreign keys" then click "OK".
• Select "Error handling options" if it is necessary for your migration and select "Run immediately" for the task.

If there were any errors during the task execution, find a location of error logs to get more information on the issues. Once the MySQLyog wizard is completed successfully, it is the time to validate the execution results and compare the data.

Have any questions? Contact us