Upgrade from Earlier Versions of the Database

Method #1: The Configuration Utility

Follow the directions in the chapter "The Configuration Utility" to upgrade the database.

Method #2: Manual Configuration

Before Upgrading

Before upgrading, be sure to back up your existing database.

Convert the SQL Database Structure

In order to work with the latest version of Intercept Studio, the prior installation's SE-Viewer database must be upgraded by running the appropriate database conversion SQL scripts.

Use Microsoft SQL Server Enterprise Manager to navigate to the server that contains the Intercept Studio 'seviewer' database.
Use Enterprise Manager to back-up the 'seviewer' database.
Using the Enterprise Manger 'SQL Query Analyzer', load and run the following SQL scripts against the 'seviewer' database. The scripts are located in the 'Database' directory under the Intercept Studio installation. (By default, Intercept Studio is installed at: 'C:\Program Files\AVIcode\Intercept'. Please note that on x64 installations, the server agent and its associated configuration files may be found under "Program Files x86", while other components will be under "Program Files".)

Depending upon your prior installation of Intercept Studio, you must selectively run the following upgrade scripts in the correct order. Each script is named following the format:

Upgrade_MajorNumA_MinorNumA_to_MajorNumB_MinorNumB.sql

You must run each upgrade script, in order, starting with the script for your existing installation, continuing with each intermediate upgrade, and finishing with the upgrade to the new version. For example, if you wanted to upgrade from version 1.2 to version 3.0, the you would have to run all of the following scripts in the order presented:

Example:

Upgrade_1_2_to_2_3.sql
Upgrade_2_3_to_2_3_3.sql
Upgrade_2_3_3_to_2_3_4.sql
Upgrade_2_3_4_to_3_0_0.sql

Configure the SE-Viewer Database Connection

The new installation of SE-Viewer has over-written the prior installation's database configuration settings. These database configuration settings must be returned to their prior state in order for SE-Viewer to connect to the newly upgraded Microsoft SQL database. Please follow the directions under Configure to Use SQL Server under 'First-time Installation'

Last update: Thursday, December 09, 2010 02:15:01 PM