This article describes how to migrate a DualShield server with Microsoft-SQL to a DualShield server with MySQL.
1 - Install a new DualShield authenticatiron 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 the new MySQL using the MySQL Migration Wizard
Expand |
---|
Include Page |
---|
| Run MySQL Migration Wizard |
---|
| Run MySQL Migration Wizard |
---|
|
|
6 - Fix issues after the database migration
Expand |
---|
Include Page |
---|
| Fix MySQL Migration Issues |
---|
| Fix MySQL Migration Issues |
---|
|
|
...