Run the Database Creation Script (Oracle) - Brainware for Invoices - 23.1 - 23.1 - Brainware - external

Brainware for Invoices Installation Guide

Brainware for Invoices

The database creation script for Oracle has one parameter in the SQL file. The overwriteTables parameter controls whether you want the SQL script to overwrite existing database tables.

To configure the database creation script for Oracle, complete the following steps.

  1. Open the 'MasterSQL - Oracle.sql' file.
  2. Navigate to the declaration line overwriteTables char(1) = '1'.
  3. If you want the script to abort if the database already contains any BFI data, set the value of the overwriteTables to '0'.
  4. If you want the script to overwrite any BFI data that already exists in the database, set the value of overwriteTables to '1'.
  5. Execute the script.