Upgrading existing data sources for version 6.1

Upgrade existing databases to be able to support the updated version of NexJ Contact.

In a production environment, use the Database Schema Tool in NexJ Studio to generate the SQL scripts to upgrade the tables and than provide the scripts to the database administrators who have appropriate database access.

In test or development environments, if you have the appropriate access, you may also be able to use the Data Load Tool to issue the upgrade command directly against the database.

To upgrade the existing data sources for version 6.1 :
  1. In NexJ Studio, click the drop-down arrow next to 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 upgrade - generate an SQL script for upgrading the schema.
    • Select the following existing data sources listed in the Data Source field:
      • DefaultRelationalDatabase
      • BI_1_BI_Database
      • Conversation
      • ecr:ECR
      • msg:Messaging
      • StagingDatabase
  3. Click Run.
  4. Provide the scripts to a database administrator who has appropriate permissions to modify the databases.
    The DBA should run the scripts against the affected databases.
The data sources have been upgraded.