ReplicationServer

(PK) ReplicationServerKey

int NOT NULL

The unique identifier for the replication server.

ReplicationServerName

nvarchar(255) NOT NULL

The name of the replication server.

Description

nvarchar(512) NULL

The description of the replication server.

SFPath

nvarchar(260) NULL

The local store-and-forward path associated with the replication server for this instance of AVEVA Historian.

SFFreeSpace

int NOT NULL

The free space for the store-and-forward path in MB.

CompressionEnabled

bit NULL

Used to specify whether compression should be enabled for the tag. 0 = No compression; 1= Compression.

UserName

nvarchar(255) NULL

The user name for logging in to the replication server. (AuthenticateWithAAUser must be 0.)

Password

nvarchar(512) NULL

The encrypted password for logging in to the replication server. (AuthenticateWithAAUser must be 0.)

TCPPort

int NOT NULL

The TCP port to use to log in to the replication server.

SummaryReplicationNamingScheme

nvarchar(512) NULL

The naming rule for summary replication tags. If ReplicationGroupKey is NULL, the naming rule is used from the ReplicationServerName scheme. If ReplicationServerName is NULL, the naming rule is used from the SummaryReplicationNamingScheme system parameter.

SimpleReplicationNamingScheme

nvarchar(512) NULL

Naming rule for simple replication tags. If NULL the naming rule specified in the simple replication naming scheme system parameter is used.

BufferCount

int NOT NULL

The number of 64 KB buffers pre-allocated for buffering data. This number may need to be increased to accommodate high data rates. This value is of data type int, with a default of 128.

Bandwidth

int NOT NULL

The bandwidth in kbps used between tier-1 and tier-2. -1 = unlimited.

MinSFDuration

int NOT NULL

The minimum duration, in seconds, for the replication service server node to function in store-and-forward mode. The replication service server node functions in store-and-forward mode for this length of time even if the condition that caused replication service server node to function in store-and-forward mode no longer exists. The maximum duration is 3600 seconds, and the minimum is 0 seconds.

ConnectionDetails

nvarchar(1024) NULL

Internal use only.

IntegratedSecurity

bit, NULL

Indicates whether this will be used for local replication connection and not for remote. (For remote replication, users are expected to provide username and password.)

ReplicationEvents

bit, NOT NULL

Specifies whether events are to be replicated. This applies only to remote servers.

ChangeVersion

timestamp, NOT NULL

Internal use only.

Status

tinyint NULL

Automatically updated by the system if a change is made to the replication server: 0 = No change; 1 = Insertion; 2 = Modification; 3 = Deletion.