In MySQL Workbench, select Database | Migration Wizard

Click Start Migration

In Database System, select "Microsoft SQL Server"

In Connection Methods, select "ODBC Data Source"

Click "Test Connection"

Click Next

Click "Test Connection"

Click Next

Click Next

Select the "dualshield" schema

Click Next

Click Next

Click Next

Click Next

Click Next

Enable "Create s SQL script file"

Click Next

Click "Yes"

Click Next

We need to make some changes to the schema 

Select the "alert" table

Change "VARCHAR(0)" to "LONGTEXT", in the advance_options and message columns

Click the Apply button

Click Next

Click Next

This process might take a while depending on the size of the database



  • No labels