Upgrading data sources for version 8.8

You must upgrade existing databases to support NexJ CRM version 8.8.

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

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

To upgrade the existing data sources for NexJ CRM version 8.8:
  1. In NexJ Studio, 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 upgrade - generate an SQL script for upgrading the schema.
    • Select a required data sources in the Data Source field.
  3. Click Run.
  4. Repeat for each required data source.
  5. Provide the scripts to a database administrator who has appropriate permissions to modify the databases.
    The administrator should run the scripts for the applicable databases.
The data sources are upgraded.