Migrating archive data between databases

GFI FaxMaker includes a tool to export archived data from one database format to another.

This tool is useful in various scenarios, including:

Archive data can be copied between the following database formats:

Source database type Destination database type
Microsoft Access Firebird
Microsoft Access Microsoft SQL
Microsoft Access GFI Archiver
Firebird Microsoft SQL
Firebird GFI Archiver
Microsoft SQL Microsoft SQL
Microsoft SQL GFI Archiver
Important notes:
  • GFI FaxMaker Reports and Archive Viewer use the currently active archive database as configured in the GFI FaxMaker Configuration. Use the Migration tool to ensure that all archive data is included in the active database,
  • The Migration tool copies the archive data from the source database to the destination, so the data in the source database is retained.
  • Migration of data can take a long time depending on various factors such as the size of the data to migrate, disc read and write speeds and network bandwidth when migrating data to remote servers.
  • When a migration process is run and then run again using the same source and destination databases, data is not duplicated on the destination database if the source database is not altered in any way. If source database is renamed, content altered or the re-migration run on a different server, data may become duplicated on the destination database..
Using the Database Migrator tool
  1. From the GFI FaxMaker Configuration, select the Archiving node.
  2. From the right pane, click Migration Tool to open the GFI FaxMaker Database Migrator and click Next.
  3. Select a source database to copy GFI FaxMaker data from. Choose the database type and specify the source database details. Click Next.
  4. Select the destination database where data from the source database will be copied. Choose the database type and specify the destination database details. Click Next.
  5. Click Next to start migration. On completion click Close.