Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ElementDescription
manual-schema

Indicates if the schema should be manually installed.

Values: true, false

Mandatory: No.

Default value: false

is-partitioned

Indicates if the database contains partitioning.

Values: true, false

Mandatory: Yes, if manual-schema is true

dbms-version

Database version.

Values: 2005, 2008

Mandatory: Yes, if manual-schema is true

dbms-

...

type

Marked always as SQL Server (mssql).

Mandatory: Yes

dbms-

...

instance

MS-SQL Server instance name. (Must always be uppercase).

Values: String

Mandatory: Yes

dbms-use-win-

...

authentication

Indicates whether the PMBD will be connected using OS authentication.

Values: Boolean

Mandatory: No

Default value: false

Info

...

All focals must be on the Windows server and the service must be configured to run with the user that has privileges on the PMDB.

When using windows authentication, the CLI must be run by a user with permissions to connect to the SQL Server database.

...

 dbms-database

Name of the MS-SQL Server database.

Values: String

Mandatory: Yes

...

 dbms-dba-

...

user

User name for the MS-SQL Server user with DBA privileges to install the schema.

Values: String

Mandatory: Not mandatory if dbms-use-win-authentication is true.

dbms-dba-encrypted-

...

password

Password for the MS-SQL Server user with DBA privileges.

Values: Encrypted String

Mandatory: Not mandatory if dbms-use-win-authentication is true.

Editable: No

Alternatively the dbms-dba-clear-password can be used, allowing you to specify a clear password instead of an encrypted string. For more information, see Encrypt command on page 148.

dbms-file-

...

groups

All tables will be created under this file group.

Values: String

Mandatory: No

dbms-

...

collation

New database will be created using this collation.

Values: String

Mandatory: No

Default value: SQL_Latin1_General_CP1_CS_AS

dbms-data-

...

growth

New database data file auto growth size in MB.

Values: Integer

Mandatory: No

Default value: 512

dbms-data-

...

size

New database data file size in MB.

Values: Integer

Mandatory: No

Default value: 1024

dbms-data-

...

path

Folder under the database server where the data file will be created.

Values: String

Mandatory: Yes, if the dbms-database parameter value is a database which does not exist.

dbms-log-

...

path

Folder under the database server where the database log file will be created.

Values: String

Mandatory: Yes, if the dbms-database parameter value is a database which does not exist.

dbms-log-

...

size

New database log file size in MB.

Values: Integer

Mandatory: No

Default value: 512

...

 dbms-log-

...

growth

New database log file auto growth size in percent.

Values: Integer

Mandatory: No

Default value: 10

Installing additional parameters to servers where FocalPoints are installed

The following table lists the additional parameters needed for server installation, wherever FocalPoints are installed. These are required only if when installing the Framework FocalPoint on servers other than the Precise FocalPoint. In such cases specify the parameters below for each server and replace server-name (italic) with the real server name.

...