Answer
This guide will show you how to migrate older MailEssentials MS Access WL/AWL/BL into the new ControlLists.sdf of MailEssentials 2015. You will need to download the free version Database .NET
here.
- These instructions will work for migrating databases from GFI MailEssentials 2014 and prior.
- Open the config.mdb/autowhitelist.mdb in MS Access
- Copy the entire table to an Excel Spreadsheet
- Remove the ID column entirely
- Remove the first row with the Email and type
- Save as a .csv file
- Run Database4.exe (Database .NET) and open ControlLists.sdf
- Open the respective table to which you wish to migrate the information:
- Right-click on the table
- Select Edit > All Rows
- Right click on the table and select Import
- On the top right corner of the new window change the delimiter to a comma ( , )
- Open the .csv file and make sure that the table is filled correctly
- Click on Insert
- Repeat for the rest of the tables
Note: The IP Whitelist needs to be migrated separately since they are located in the config.mdb of both versions of GFI MailEssentials.