Upgrading the database schema

You can upgrade an existing Oracle or SQL database schema by running the appropriate upgrade scripts from the upgrade folder of the WorldServer distribution kit.

After you upgrade your database, you must upgrade the WorldServer software and the database objects and validate your database objects.

In most cases, the database schema upgrade will be performed by a database administrator. You should inform this administrator that the files required for the schema upgrade are in the upgrade folder of the WorldServer distribution kit.

The following steps provide general, high-level guidelines for upgrading a WorldServer database. If your company does not have its own database strategy, consider using this one.
  1. Inform all users prior to upgrading that the WorldServer program and database instance will be down (specify the exact time period).
  2. Disable all access to the production WorldServer database at the planned time.
  3. Back up your WorldServer system — both the files and database(s).
  4. Follow the documented steps to upgrade the WorldServer database, keeping these notes in mind:
    • It may take a while for the main upgrade script to finish running; the time depends on the size and tuning of the database, as well as on the configuration of the database server.
    • Read all log files carefully before proceeding to another step and be patient.
    • If you run into problems, send the log files to SDL Technical Support.
  5. Run the correct upgrade scripts for your Oracle or SQL Server database, and then verify that the upgrade script was executed successfully.

    The upgrade scripts are in the upgrade folder of the WorldServer distribution kit. The upgrade\1000 folder contains scripts to test your database before upgrading. The upgrade\1010 folder contains the scripts for performing and then testing the upgrade: testschema.sh (Linux) or testschema.bat (Windows).