DICENTIS
Hints and Tips | en
113
Bosch Security Systems B.V.
Configuration manual
2021.06 | V3.7 |
The DcnmDatabaseConsole tool also uses the environment variables to create the database.
So, after setting the environment variables and opening the console window, the remote
database is created using “DcnmDatabaseConsole -n”
Note:
When using the DcnmDatabaseConsole.exe the user credentials must have the rights
required to create the database.
The environment variables can be overruled by passing arguments to the
DcnmDatabaseConsole.exe (For help on the command-line syntax and the available options,
execute the command with the -? option):
–
-s to pass the server name and the instance name
–
-u to pass the user-ID for SQL-authentication (Windows authentication when omitted)
–
-p to pass the user-ID’s password
–
-d to pass the databasename
Remote and target
The DcnmDatabaseConsole.exe also includes command line options to do database backup
and restore functions. These functions are restricted/limited when used in combination with a
remote SQL-server.
Remote machine
: where the DICENTIS services are running.
–
A new database can be created from the remote machine.
–
A database backup can be started from the remote machine
Target machine
: Where the database is running.
–
A database can only be restored from the target machine.
Windows Authentication example
This example shows how to use windows authentication to connect to the remote SQL server
named
SQLENT1
on machine
SQLSRV
.
The database to use for the system is
MainConfHall
:
Environment variable
Value
MMCN_DB_SERVER
\\SQLSRV\SQLENT1
MMCN_DB_DATABASE
MainConfHall
Database creation:
Remote
:
DcnmDatabaseConsole -n
On target
:
DcnmDatabaseConsole -s \SQLENT1 -d MainConfHall -n
SQL authentication example
This example shows how to use SQL authentication to connect to the remote SQL server
named
SQLENT2
on machine
SQLSRV
.
The user name and password to use are respectively:
DcnmUser
and
P@ssw0rd
. The database
to use is
ConfHall53
:
Environment variable
Value
MMCN_DB_SERVER
\\SQLSRV\SQLENT2
MMCN_DB_DATABASE
ConfHall53
MMCN_DB_USER_ID
DcnmUser