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. |