Database Migration

The Database Migration node allows you to easily migrate the IceWarp Server database from one database server to another one.

You may want to do this to change the physical server or to change the database technology in use (for example, upgrading from MS Access to MySQL or MS SQL Server).

database_migration

Field	Description
Database	Select which IceWarp Server database you want to migrate from the dropdown list. Available databases are: Accounts Database IceWarp Anti-Spam Database GroupWare Database
Source DSN	Click the Source DB button to define the source DSN for migration. The Database dialog opens.
Destination DSN	Click the Destination DB button to define the target DSN for the migration. The Database dialog opens.
Repair UTF-8 character set	Tick the box if you want the server to check if the source database character set is valid UTF-8. If the data contains characters that are not valid UTF-8 ones, these characters are removed.
Start Migration	Click the button to start migration process.

database_dialog

Field	Description
DSN	Select the DSN of the database.
Server	Enter the hostname of the database server.
Username	Enter a username to access the database.
Password	Enter the password for the use.
Syntax	Select the database technology in use (this is required because of minor differences in SQL syntax).
Driver	Select a driver for the database technology you are using.
Test Connection	Click the button to test that IceWarp Server can access the database with the details entered.