Page Comparison

XDB.DatabaseType

Sets the database type (MS SQL or MySQL (Maria DB)).

MySQL, MSSQL

None

MySQL

XDB.UserID

If the integrated security mechanism is not used, the specified user will be Username that is used to connect to the database.

String

None

sa

XDB.Password

If the integrated security mechanism is not used, the specified password will be Password that is used to connect to the database.

String

None

netxnetx_123456

XDB.Hostname

The host name or IP address where the database is running. Use ".", "127.0.0.1", or "localhost" for connecting to the local machine.

String, IP-address

None

.

XDB.Database

Database name to use. If not set, the default database name "netx_ef_<workspace>" will be used. Following special characters are not allowed: 

?*|"{}\';

String

None

<empty>

since 4.1.2010

XDB.Port

Communication port of database. If not set, the port will not be provided in the connection string – otherwise, the specified port number will be used.

None, 1 – 65535

None

None

XDB.Instance

(MSSQL only) Instance name of the used database.

String

None

NETX_SERVER_SQL

XDB.ConnectionTimeout

Connection timeout

0 – 30

s

15

XDB.CommandTimeout

Command timeout

0 – 3600

s

60

XDB.LongCommandTimeout

Command timeout in seconds for long running commands like selecting trending values, auto purge or report generation.

0 – 7200

s

300

XDB.AutoPurge

(MSSQL with SQL Server Express Edition only, 10 GB max. database size) If the cyclic check finds the database is more than 9 GB filled then the oldest trending data is deleted until the database size dropped below 8 GB.

ON, OFF

None

OFF

XDB.DeleteOldTrending

ON: The values of deleted trending definitions will be deleted from the database.

OFF: The values of deleted trending definitions will be kept in the database, e.g. for future evaluation.

ON, OFF

None

ON

XDB.SkipMigration

BMS Platform version < R1 Build 2000 was using a different SQL schema. Therefore the Core Server tries to start a migration from the old schema to the new. This migration process can be deactivated by setting this option to OFF. 

ON,OFF

None

OFF