Backup your database before upgrading Aurea List Manager. If you encounter any problem while performing the upgrade, it might be impossible to recover your data without a backup.

For more information about how to back up MSDE (Microsoft SQL Desktop Engine), see Backing Up MSDE.

For other databases, please consult your vendor's documentation.

The current database structure for outgoing mail requires more space than versions 7.8 and earlier. Before upgrading, check to see that you have sufficient space in your database to perform the upgrade successfully.

If your database is close to its size limit, or you are concerned about the upgrade taking too long, you may reduce the size of the outmail_ table by taking the following steps:

1. In the left navigation bar, click Utilities > Administration > Server > Server Settings > Automatic Maintenance > Purging Old Data.
2. Set Clean Outgoing Mail Queue to 1. 0 keeps this data forever.
3. Click Save.
4. In the left navigation bar, click Utilities > List Settings > Automatic Maintenance > Purging Archives.
5. Set Keep Mailing and Clickthrough Data for How Many Days to 1. 0 keeps this data forever.

6. Click Save.
7. Kindly allow 24 hours to elapse before performing the upgrade. Aurea List Manager automatically reduces the size of your database as part of its nightly maintenance processes.
8. If you are concerned about the upgrade taking too long, you may also choose to shorten the lyrMetricEvents table, where Aurea List Manager stores performance data. This table contains millions of rows, and it may take several hours to upgrade this table.
9. To limit the amount of data in this table:

•  In the left navigation bar, click Utilities > Administration > Server > Server Settings > Automatic Maintenance > Purging Old Data.
•  Set Purge Old Metric Events to 1. 0 keeps this data forever.
•  Click Save.
•  Kindly allow 24 hours to elapse before performing the upgrade. Aurea List Manager automatically reduces the size of your database as part of its nightly maintenance processes.

• We recommend that you evaluate ListManager on a test machine. If you prefer to use your production Aurea List Manager server, only do so if you plan to upgrade it to the current version.
• Do not use the release on your production server if you might want to go back to an older version of Aurea List Manager. Once you upgrade, you cannot downgrade to the older version.

• You can use the MSDE version of Aurea List Manager with the standard feature set without a serial number in a limited capacity (200 members max, MSDE installed locally).
• If you want to test a larger or external database, evaluate the Pro feature set, or connect Aurea List Manager to Microsoft SQL Server or Oracle, please contact your account representative to obtain an evaluation Serial Number.
• Serial codes from versions 4.2 and lower are no longer valid, so contact an account representative to purchase an upgrade and to receive a new serial code. Your account representative can also tell you if your serial code allows you to upgrade to the current version.
• To determine if you are allowed to upgrade Aurea List Manager, check Max Version and Last Day to Upgrade in Utilities > Administration > Server > Operational Statistics > License Capabilities. For more information, see License Capabilities

Aurea List Manager uses the Aurea List Manager web server included with Aurea List Manager. Aurea List Manager's web server may coexist with your web server and can be installed on a higher port if port 80 is taken.

Aurea List Manager uses its DNS resolver. If you have a firewall, you must configure it so that Aurea List Manager can resolve DNS on port 53.

If you have a firewall and you are upgrading from an earlier version, it is highly recommended to test Aurea List Manager on a development server before you upgrade your production server to ensure Aurea List Manager can perform its DNS resolutions properly.

For more information, see Your Firewall and ListManager

The old words_table is no longer be available after upgrading, which may affect some custom programs. For more information about the new database table structure, see the Programmer's guide.