Using SQL Scripts

The iWay TPM installer creates a sql subdirectory under the root installation (for example, C:\iWay_TPM\tpm\sql) where several SQL scripts are included for Microsoft SQL Server (MSSQL), Oracle, and PostgreSQL (Postgres) databases, as shown in the following image.

MSSQL:

• tpm_mssql.sql. Creates a new iWay TPM database on MSSQL, including all required tables.
• tpm_mssql_drop_tables.sql. Drops (deletes) existing iWay TPM tables on MSSQL.
• tpm_mssql_migration.sql. This SQL script is for an existing instance of iWay TPM, which will migrate your database from an older version of iWay TPM to the latest version of iWay TPM.

Oracle:

• tpm_oracle.sql. Creates a new iWay TPM database on Oracle, including all required tables.
• tpm_oracle_drop_tables.sql. Drops (deletes) existing iWay TPM tables on Oracle.

PostgreSQL (Postgres):

• tpm_postgres.sql. Creates a new iWay TPM database on PostgreSQL, including all required tables.

Pay close attention to any messages displayed by the iWay TPM installer regarding SQL scripts during the iWay TPM database connection test phase. These messages will determine which SQL script(s) you must run.

The following image shows an SQL script being run using Microsoft SQL Server Management Studio.

The SQL script was pasted into a query window, the database focus was changed to the database that needed to be modified, and then the query was executed.