Example table replication definition file

The table replication definition file defines how the ObjectServer gateway replicates tables between the source and target ObjectServers. Use this example to familiarize yourself with how the file works.

The following example shows a table replication definition file:

REPLICATE INSERT, DELETE FROM TABLE 'alerts.status'
	USING MAP 'StatusMap'
ORDER BY 'Serial ASC'
FILTER WITH 'Severity=!5'
SET UPDTOINS CHECK TO FORCED
AFTER IDUC DO 'Location=\'PASSED BY GW\''
CACHE FILTER  'ServerName IN (\'NCOMBS_P\',\'NCOMBS_B\')';

REPLICATE ALL FROM TABLE 'alerts.journal'
	USING MAP 'JournalMap';

REPLICATE ALL FROM TABLE 'alerts.details'
	USING MAP 'DetailsMap';


##############################################################################
# NOTE: If replication of the user related system tables is required, uncomment
# the replication definitions below. The associated maps will also need to be
# uncommented.
##############################################################################

# REPLICATE ALL FROM TABLE 'security.users'
#	USING MAP 'SecurityUsersMap'
#	INTO 'transfer.users';
#
# REPLICATE ALL FROM TABLE 'security.groups'
#	USING MAP 'SecurityGroupsMap'
#	INTO 'transfer.groups';
#
# REPLICATE ALL FROM TABLE 'security.roles'
#	USING MAP 'SecurityRolesMap'
#	INTO 'transfer.roles';
#
# REPLICATE ALL FROM TABLE 'security.role_grants'
#	USING MAP 'SecurityRoleGrantsMap'
#	INTO 'transfer.role_grants';
#
# REPLICATE ALL FROM TABLE 'security.group_members'
#	USING MAP 'SecurityGroupMembersMap'
#	INTO 'transfer.group_members';