Defining the database structure

SQL scripts define the structure of the Datacap application databases for DB2® , Microsoft SQL Server, or Oracle databases.

About this task

Use the SQL scripts that are installed as part of the Datacap installation to create an empty database structure. You create this database structure for the Datacap Administration, Engine, and Fingerprint databases.

Procedure

To define the database structure:

  1. Go to C:\Datacap\support\DBScript and select the scripts for the database you want to create:
    Option Description
    DB2 DB2_Adm_Base.sql

    DB2_Eng_Base.sql

    DB2_FP_Base.sql
    Microsoft SQL Server SQL_Adm_Base.sql

    SQL_Eng_Base.sql

    SQL_FP_Base.sql
    Oracle Oracle_Adm_Base.sql

    Oracle_Eng_Base.sql

    Oracle_FP_Base.sql
  2. For DB2 , start the DB2 CLPPlus tool and log on as the owner of the database schema.
  3. For SQL Server, start SQL Server Management Studio or SQL Server Enterprise Manager and log on to the server as the administrator.
  4. For Oracle, start the SQLPlus tool and log on as the owner of the database schema.
  5. Create the database by following the instructions that are provided in the Microsoft SQL Server or Oracle documentation that was provided with your database.
  6. Open the appropriate scripts in the tool and run them to define the structure of the Datacap application databases.