Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Expand

Include Page
Install MySQL Workbench
Install MySQL Workbench


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

Expand

Include Page
Create ODBC data source for MS-SQL
Create ODBC data source for MS-SQL


4 - Stop the DualShield service on both the old and new servers



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

Expand

Include Page
MySQL Migration Wizard
MySQL Migration Wizard


6 - Fix issues after the database migration 

Expand

Include Page
Fix MySQL Migration Issues
Fix MySQL Migration Issues