Creating a database manually

To create a database manually:

  1. Create a blank database.

For a PostgreSQL database:

  1. For an SQL database, run the Description.sql script.
    For an Oracle database, run the Description_Oracle.sql script.
    For a PostgreSQL database, run the Description_PostgreSQL.sql script.
    Note: By default, the scripts are placed into the C:\inetpub\wwwroot\FlexiCapture12\Server folder on the computer where the Application Server is installed.
  2. For an SQL database, run the DBInitFill.sql script.
    For an Oracle database, run the DBInitFill_Oracle.sql script.
    For a PostgreSQL database, run the DBInitFill_PostgreSQL.sql script.
    Note: By default, the scripts are placed into the C:\inetpub\wwwroot\FlexiCapture12\Server folder on the computer where the Application Server is installed.
  3. Provide a unique identifier for the database:

INSERT INTO dbo.Settings( Name, Value, ProjectId, BatchTypeId, UserId, Workstation, RoleId, ProcessingStage) VALUES ('DatabaseGUID', NEWID(), NULL, NULL, NULL, NULL, NULL, NULL )

For a PostgreSQL database:  

INSERT INTO Settings (Name, Value)  

VALUES ('DatabaseGUID', upper(md5(clock_timestamp()::text)::uuid::text));  

  1. Add the first user:

INSERT INTO principal (Name, FullName, EMail, PasswordHash, PasswordReset) values (N'Login', N'FullName', N'email', '', 0)

For a PostgreSQL database:

INSERT INTO Principal (Name, FullName, Email, PasswordHash, PasswordReset) values ('Login', 'FullName', 'email', '', false);

where

  • Login is the login that the user will use,
    Important! You must specify the login of the Windows user that will be used to open the Administration and Monitoring Console when connecting to the database.
  • FullName is the full name of the user as displayed in their profile, and
  • Email is the user’s e-mail address.
  1. Specify the system administrator roles for the newly created user:

INSERT INTO principalpermission (PrincipalId, RoleType, IsAllowed) values (1, 10, 1);

For a PostgreSQL database:

INSERT INTO principalpermission (PrincipalId, RoleType, IsAllowed) values (1, 10, true);  

  1. Connect to the newly created database using the Administration and Monitoring Console.

SQL database users

For details about user permissions, see Permissions required for creating and configuring a Microsoft SQL database.

12.04.2024 18:16:02

Please leave your feedback about this article

Usage of Cookies. In order to optimize the website functionality and improve your online experience ABBYY uses cookies. You agree to the usage of cookies when you continue using this site. Further details can be found in our Privacy Notice.