Using The Database Migration Tool In Icewarp
Posted by Gary, Last modified by on 15 November 2007 03:19 PM

Using The Database Migration Tool

 

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 tab > Tools > Database Migration

DB Migration

 

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

DB Migration

 

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

DB Migration

 

  • Press Destination DB...

 

  • Select SQLite driver

DB Migration

 

  • Fill database name e.g. demodb.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

DB Migration Start

 

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

 DB Migration YES

 

  • 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 database now?". Press Yes if you want to connect new database.

 DB Migration 1231312

 

  • 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 tab - Tools - Database Migration

 

  • Select database you want to migrate 

 

  • 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 database 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 20th June 2014 - version 11.0.1 - by Valentin