Through the Database Manager, Acoustic™ Tealeaf databases can be upgraded all at one time or individually.
The databases must be upgraded in a specific order. This order is managed for you in All Databases mode.
When you upgrade databases individually, you must complete the upgrade in the order described in the procedure for Single Database mode.
In All Databases mode
Use this procedure to upgrade your databases in All Databases mode.
- Run the following command:
<Tealeaf_Install_Directory>\Reporting\TeaLeafDatabaseManager.exe
- Enter your connection information.
- In the menu, select Mode > Database Setup > All Databases.
- From the Action drop-down, select
Upgrade
. - Click OK.
Note: After you begin installation or upgrading in All Database Mode, canceling interrupts the process after the requested action is completed on the current database. The actions on the current database and all previous databases are retained, and any remaining databases are left untouched. You might want to revert to the backup or make adjustments before you complete the action.
- After the operation completes, review the output window.
Be sure to review the Failed Statements pane to verify that all statements were successfully run.
Note: After completion of an upgrade, the Database Manager attempts to start the SQL Server services on the host machine, in case they stop at some point. If the Database Manager fails to start them on a remote machine, an error message may be generated. If the services are operational, then this message is harmless; a restart of SQL Server is not required during upgrade.
In Single Database mode
Follow these steps in the order shown to manually upgrade your Acoustic Tealeaf databases.
The databases must be upgraded in the following order.
- The System database must be upgraded first.
- The Reports database must be upgraded second.
Note: If you install or update the System database, you must install or reinstall the event definitions through the Database Manager at some later point in the installation process.
- The other databases can then be created and updated in any order.
Perform the following steps on the Portal server.
- Run the following executable:
<Install_Directory>\Reporting\TeaLeafDatabaseManager.exe
- Enter your connection information.
- Upgrade the System database:
Note: The System database must always be created first.
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
System
. - From the Action drop-down, select
Upgrade
. - Click OK.
- After the operation completes, review the output window.
Be sure to review the Failed Statements pane to verify that all statements were successfully run.
- Close the output window.
- Upgrade the Reports database:
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
Reports
. - From the Action drop-down, select
Upgrade
. - Click OK.
- After the operation completes, review the output window.
Be sure to review the Failed Statements pane to verify that all statements were successfully run.
- Close the output window.
- Upgrade the RS Extractor database:
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
RS Extractor
. - From the Action drop-down, select
Upgrade
. - Click OK.
- After the operation completes, review the output window.
Be sure to review the Failed Statements pane to verify that all statements were successfully run.
- Close the output window.
- Upgrade the Statistics database:
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
Statistics
. - From the Action drop-down, select
Upgrade
. - Click OK.
- After the operation completes, review the output window.
Be sure to review the Failed Statements pane to verify that all statements were successfully run.
- Close the output window.
- Upgrade the Tealeaf cxReveal database:
Note: The Tealeaf cxReveal database requires special setup.
- In the menu, select Mode > Database Setup > Single Database.
- From the Database drop-down, select
Search
. - From the Action drop-down, select
Upgrade
. - Click OK.
- Close the output window.
- In single database mode, after you complete the upgrade, you must install the event definitions.
After you complete the upgrade of the databases, you must install the event definitions for the current release.
Migrate Search data
This step migrates your Acoustic Tealeaf cxReveal Search database (TL_SEARCH
) to the schema for the current release.
This step migrates only the current day's table formats to the new format. Migration of historical data from previous days is performed by the Attribute Indexing session agent upon initial startup of the Tealeaf cxReveal capture pipeline.
- Log in to the Report Server as an administrator.
- Navigate to the following directory: <install_directory>\Reporting
- Launch
TealeafDatabaseManager.exe
. - Enter login information.
- From the menu, select Mode > Database Management > Migrate Search Data.
- To migrate Search data, click OK.
- The database data is migrated to the new schema.