MSSQL to MySQL conversion

When you migrate from MS SQL to MySQL, apart from migrating the data, you should also migrate the application code that resides in the database.

Earlier we discussed how to migrate MS SQL to MySQL database using the WorkSQL Workbench tool.

As part of the migration, it will only convert tables and copy the data, but it will not convert triggers, views and stored procedures. You have to manually convert these over to MySQL database.
(more…)