Siebel Analytics Scheduler Guide > Using Siebel Analytics Scheduler > Installation, Upgrade and Configuration Overview >

Upgrading from Siebel Analytics Version 7.0.4

The schema tables required to run Siebel Analytics Scheduler version 7.5 have changed from those of Siebel Analytics version 7.0.4. Therefore, to upgrade from Siebel Analytics version 7.0.4 to version 7.5, you need to create new Scheduler tables and migrate your data from those of Siebel Analytics version 7.0.4 into the new tables. For information about creating the Scheduler tables, see Siebel Analytics Installation and Configuration Guide. For information about migrating your data, see Migrating Data from Version 7.0.4 Tables to Version 7.5 Tables.

If you are using Siebel Analytics as a stand-alone product, that is, without Siebel eBusiness Applications, you can continue to use the version 7.0.4 schema by running a registry script. For information on running the registry script, see Running a Registry Script To Maintain Version 7.0.4 Schema.

Table 2 shows the tables names for version 7.0.4 and the corresponding new names for version 7.5.

Table 2. 7.0.4 and 7.5 Table Names
Version 7.0.4 Table Name
Version 7.5 Table Name
NQSJOBS
S_NQ_JOBS
NQSINSTANCES
S_NQ_INSTANCES
NQSJOBPARAMETERS
S_NQ_JOBPARAMETERS
NQSERRMSGS
S_NQ_ERRMSGS

Migrating Data from Version 7.0.4 Tables to Version 7.5 Tables

Use this procedure to migrate data from version 7.0.4 Scheduler tables to version 7.5 tables.

To migrate data

  1. Locate the Schema subdirectory in the Siebel Analytics software installation directory.
  2. Execute the script migrate.SAACCT.xxx.sql where xxx is your database type.
  3. Execute the script migrate.SAJOBS.xxx.sql where xxx is your database type.

NOTE:  The data migration will be successful only if the version 7.5 tables are in the same database as the version 7.0.4 tables.

Running a Registry Script To Maintain Version 7.0.4 Schema

Use this procedure if you are using Siebel Analytics as a standalone product and want to continue to use the version 7.0.4 schema.

CAUTION:  The registry script creates entries in the registry telling the Scheduler to use the version 7.0.4 tables. After you run the registry script, the Scheduler will always look for the version 7.0.4 table names. If you later want to upgrade to the version 7.5 table names, you will need to manually delete the entries in the registry. To do so, delete the DB Column Names entry under nQuire Software\nQuire Scheduler\7.0.

To run the registry script

  1. Locate the Schema subdirectory in the Siebel Analytics software installation directory.
  2. If you are running IBM AS/400, execute Use.7.0.OS390.AS400.reg, otherwise execute Use.7.0.SchTables.reg.

 Siebel Analytics Scheduler Guide 
 Published: 18 April 2003