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 |
|---|
|
|
| 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 |
|---|
|
|