You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

This article describes how to migrate a DualShield server with Microsoft-SQL to a DualShield server with MySQL.

1 - Install a new DualShield server with MySQL as the database engine. Make sure that the FQDN of the new DualShield server is identical to the FQDN of the old DualShield server.


2 - On the new server, Install MySQL Workbench


3 - On the new server, create an ODBC Data Source for Microsoft-SQL

Before running MySQL Migration Wizard, we need to create an ODBC data source for MS-SQL

On the target server, launch the ODBC Data Source Administrator

Click Add

Select "SQL Server" 

Click Finish

Enter a Name, Description

Enter the address of the source Microsoft SQL server

Click Finish

Click Test Data Source...







4 - Migrate database from the old MS-server to new MySQL using the MySQL Migration Wizard

Unable to render {include} The included page could not be found.

5 - Fix issues after the database migration 

Before running MySQL Migration Wizard, we need to create an ODBC data source for MS-SQL

On the target server, launch the ODBC Data Source Administrator

Click Add

Select "SQL Server" 

Click Finish

Enter a Name, Description

Enter the address of the source Microsoft SQL server

Click Finish

Click Test Data Source...







  • No labels