SQL scripts installed by Trading Manager

Edit online

Trading Manager installs the following SQL script files in the Trading Manager directory install_dir\tmgr_vn.n\pmgr\sql. The following descriptions apply to the scripts for Oracle, Microsoft SQL Server, Sybase, and IBM DB2.

  • Installation script (*instnn.sql): creates the tables, indexes, stored procedures, and views used by Partner Manager.
  • Database load script (*loadnn.sql): loads the database with data such as Folders, Version tables, Transaction Sets, and Functional IDs.
  • Drop script (*dropnn.sql): deletes all Partner Manager tables and data in the database.
  • Update scripts (*update82to821.sql): these upgrade your database from the 8.2 release. For customers converting from 7.8 and earlier, refer to the product readme for use of these files. These files are also used on a new customer installation of Trading Manager 8.2.1 and are described below.
    Database Script
    Oracle orainstnn.sql
    oraloadnn.sql
    oradropnn.sql
    Microsoft SQL Server sqlinstnn.sql
    sqlloadnn.sql
    sqldropnn.sql
    Sybase sybaseinstnn.sql
    sybasedropnn.sql
    sybaseloadnn.sql
    sybaseloadnn_2.sql
    IBM DB2 db2instnn.sql
    db2loadnn.sql
    db2dropnn.sql