Update a SQL Server database

The database is properly configured and running.
  • You have a user name, password, and URL to access the database server. You can create triggers, sequences, tables, and stored procedures.

  • You installed the latest JDBC driver for the database. This driver is available from the following URL:

    http://msdn2.microsoft.com/en-us/data/aa937724.aspx

To update a Platform product, get the corresponding database update scripts from Platform and update the database schema before you update the cluster. The database upgrade must be performed in two steps. First, upgrade from 3.2 to 4.1, then upgrade from 4.1 to 5.1.

  • 3.2 to 4.1

    • upgrade_sym_data_3_2_to_4_1.sql

  • 4.1 to 5.1

    • upgrade_ego_data_1_2_3u1_to_1_2_4u1

    • upgrade_sym_data_4_1_to_5_0.sql

  1. Extract the database update scripts to any directory.
  2. In the command console, change to the SqlServer/Patch subdirectory. For example, if you extracted the scripts to sym51_temp:

    cd sym51_temp/DBschema/SqlServer/Patch

  3. Run the scripts in this directory to update the database schema.

    osql -U user_name -P password -d db_name -i @update_script

    where
    • user_name is the user name on the database server

    • password is the password for this user name on the database server

    • db_name is the reporting database name

    • update_script is the name of the update script

  4. Additionally, after installation, you must copy the jdbc driver to:

    EGO_TOP/gui/1.2.4u1/lib

    EGO_TOP/perf/1.2.4u1/lib