Adding the NJStatVersion table to the StatDatabase data source for version 8.8

If you are upgrading from NexJ Contact version 7.1 or earlier, you must add the NJStatVersion table for the StatDatabase data source.

Note: This is a developer task and must be performed in NexJ Studio by a person with access to the model.

You can add the version table in one of the following ways:

  • If you do not want to retain the persisted statistics in the StatDatabase data source, you can use the recreate command to drop and recreate all tables in the data source. Unless you have a good reason for doing so, we recommend recreating the StatDatabase data source.
  • If you want to retain the persisted statistics in the StatDatabase data source, you must use the create command to generate an SQL script for creating the database tables. Then, you must extract and execute the portion of the script that defines and populates the version table.

To create the NJStatVersion table for the StatDatabase data source:

  1. Open NexJ Studio.
  2. If you do not need to retain persisted statistics in the StatDatabase data source:
    1. Click the down arrow beside the Run Tool button and select Data Load Tool.
    2. Complete the Database Schema Tool dialog as required.
      Ensure you specify the following information:
      • In the Command field, select recreate - drops and recreate all tables, then imports the data.
      • In the Data Source field, select StatDatabase.
      The Data Load Tool dialog closes and the tables recreate.
  3. If you must retain persisted statistics in the StatDatabase data source:
    1. Click the down arrow beside the Run Tool button and select Database Schema Tool.
    2. Complete the Database Schema Tool dialog as required.
      Ensure you specify the following information:
      • In the Command field, select create - generate an SQL script for creating the schema.
      • In the Data Source field, select StatDatabase.
      The Database Schema Tool dialog closes and the script file is generated.
    3. From the generated SQL script, extract and execute the portion of the script that defines and populates the NJStatVersion table.
  4. Manually update the value in the version column of the NJStatVersion table to match the version in the NJVersion table that you are upgrading from.
The NJStatVersion table has been added to the StatDatabase data source.
You can now upgrade your data sources.