Upgrading your Harvest 2.x database to Telligent Analytics 3.0 is automated when you use the upgrade script. Do the following to run the script:
- Locate the SQL script TelligentAnalytics_Upgrade_BaseSchema_Sprocs.sql file in the installer files under the SQL folder.
- Run this script against your Harvest 2.x database to upgrade the base schema and stored procedures to work with Telligent Analytics 3.0.
After executing this script, your database will be compatible with Analytics 3.0.
Important: You must next install a new site (or replace the Web files for your existing site) and install the updated Tasks service for your Analytics site.
Any existing report sites in your upgraded database will not show up in Analytics 3.0. You can either recreate them in the Control Panel (recommended), or use the TelligentAnalytics_Upgrade_Report_Site.sql script to upgrade them individually.