Products Downloads


French version


 

This section contains the specific database parameters for the Microsoft SQL Server DBMS (v7.0 and later): directory, backup unit, etc.


If using the section in the Java version of the database management tool, only the "General settings" section below applies.


This section is not mandatory.


[SQL Server]

data_file = C:\MSSQL\DATA\MyBaseData.dat, 10M

log_file = C:\MSSQL\DATA\MyBaseLog.dat, 5M


Parameter

Type

Mandat.

Default

Description

General settings

UserUtil

string

no


Used to impose a default connection profile if the profile is not specified in the tool's settings.

PasswordUtil

string

no


Used to impose the default user profile password.

GrantedErrors

string

no


List of SQL error codes (in an absolute value, i.e. unsigned), separated by commas.

The listed error codes are ignored when interpreting a SQL script and do not stop processing.

GrantedSQLStates string no

List of SQLSTATE error codes, separated by commas.

The listed error codes are ignored when interpreting a SQL script and do not stop processing.

This parameter acts as a complement to the "GrantedErrors" parameter for DBMSs that do not return SQLCODE codes.


Creation

data_file

string

no


Data file of the database.

data_file_size

num

no

10

Initial size of the data file (megabytes).

data_file_size_max

num

no

-1

Maximum size of the data file (megabytes), or –1 if unlimited.

data_file_size_inc

num

no

5

Size of the data file's increments (megabytes).

log_file

string

no


Database log file.

log_file_size

num

no

10

Initial size of the log file (megabytes).

log_file_size_max

num

no

-1

Maximum size of the log file (megabytes), or –1 if unlimited.

log_file_size_inc

num

no

2

Size of the log file's increments (megabytes).

CfgScript

string

no


Name of the database configuration script.

This script is executed after the base is created, but before the files (PDM) are created.

This script can contain SQL commands and escape sequences.

A typical application might be a user creation script for Oracle or SQL Server bases.


Backup

backup_device

string

no


Name of the backup unit.


Restoration

backup_device

string

no


Name of the backup unit.

backup_number

num

no

0

Backup number.

move_files

string

no

calculated

Moves files.

force_overwrite

bool

no

0

Overwrites an existing database.


↑ Top of page

  • Aucune étiquette