Page Comparison

XDB.DatabaseType

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

MySQL, MSSQL

None

MySQL

XDB.UserID

Username that is used to connect to the database.

String

None

sa

XDB.Password

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 MS SQL Server only: Name of the used database instance.

String

None

NETX_SERVER_SQL

XDB.UseDefaultInstance

If enabled, the server connects to the default i.e. unnamed database instance of the MS SQL Server.

ON, OFF

None

OFF

XDB.ConnectionTimeout

Connection timeout in seconds.

0 – 30

s

15

XDB.CommandTimeout

Command timeout in seconds.

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 MS 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 introduced a different new SQL database schema. Therefore Since that version, the Core Server tries to start a migration migrates from the old schema (database name NETX4_) to the new . This migration process can be deactivated by setting one (NETX_). Enable this option to OFFdisable this migration. 

ON,OFF

None

OFF