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.

For Symphony 4.1, get upgrade_sym_data_3_2_to_4_1.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 sym41_temp:

    cd sym41_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.3u1/lib

    EGO_TOP/perf/1.2.3u1/lib