Using The Database Migration Tool In Icewarp
Posted by , Last modified by on 01 August 2012 05:20 PM

To transfer data from your current database to a new database, you simply need to follow the steps below.

 

Migration to new SQLite database

  • Open up the Icewarp Console and go to System -> Tools -> Database Migration

  • Select database you want to migrate (Account, Anti-Spam, Grouware)

 

  • Press Source DB...

 

  • Check if your current database is selected and press Test connection if test is successful press OK on both windows and continue to next step, if not check if driver, syntax, server, username or password is set correctly.

 

  • Press Destination DB...

  • Select SQLite driver

 

  • Fill database name e.g. newdatabase.db, press Test connection button this will create new blank SQLite database in Icewarp installation folder. If you want to specify different location press ... button next to Database field and specify path and database name there. If connection test passed successfully press OK on both windows

 

 

  • When both, source and destination databases, are properly connected you can start migration. Press Strat button to start migration

 

  • Confirmation dialogue will appear press Yes to continue the migration. Migration process is copying data from old to new database, data in source database remain untouched, but columns in target database will be removed, when you specified non-existing database it will just create new tables in target database.

 

  • During migration process is displayed progress bar for each item in database at the end of migration will appear log and dialogue "Do you want to switch to the destination DSN now?". Press Yes if you want to connect new database.

 

  • Now is your server using new database that containins data from old database

 

 

Migration to new non-SQLite database

  • Create a blank, new database in whatever format you can support.(Microsoft SQL, MySQL, etc.)

 

  • Create a new ODBC DSN that points to the new blank database.

 

  • Open up the Icewarp Console and go to System -> Tools -> Database Migration

 

  • Select database you want to migrate (Account, Anti-Spam, Grouware)

 

  • Press Source DB...

 

  • Check if your current database is selected and press Test connection if test is successful press OK on both windows and continue to next step, if not check if driver, syntax, server, username or password is set correctly.

 

  • Press Destination DB...

 

  • In the Destination DSN section place the ODBC DSN of the database you created.

 

  • When both, source and destination databases, are properly connected you can start migration. Press Strat button to start migration

 

  • Confirmation dialogue will appear press Yes to continue the migration. Migration process is copying data from old to new database, data in source database remain untouched, but columns in target database will be removed, when you specified non-existing database it will just create new tables in target database.

 

  • During migration process is displayed progress bar for each item in database at the end of migration will appear log and dialogue "Do you want to switch to the destination DSN now?". Press Yes if you want to connect new database.

 

 

When you migrated Restart Icewarp's Services and then check make sure that all the accounts exist and do a test to make sure they can log in, create event, create contact add address to black/whitelist.

updated 15th June 2011 - version 10 - by TZ