Previous topicNext topic
 Link Technologies - LinkSOFT Documentation 
Help > Link Web Applications Portal > Replication >
Servers

Overview

Servers are used to define a SQL Database Server.

The following functions are available:

  1. Defining a server
  2. View Server Status
  3. Creating a Branch database  

Steps to define a server:

  1. Edit the record. Refer to Figure 1
    1. Description - Enter a description to identify the server
    2. Physical Address - This is the address where the server is located
    3. Server Name -  Name of server where the database is hosted. E.g HQ, Branch A, Branch B, etc. The server name must uniquely identify the server in the replication setup.
    4. Database Name - Database name to be used with the Server Name.
    5. Mask - This is a two character unique identifier for all transactions created on this database. Please make sure that you use a unique two digit identifier for each database server.
    6. Server Type - Tag a server as either "Head Office" or "Branch". There should be only 1 server tagged to "Head Office" in the entire replication network. All other servers should be tagged as "Branch".
    7. Active - Tick this flag if the server is available for replication
    8. Create Branch Database - Tick this flag to create a branch database.
  2. Locations   - Locations are used to restrict transactional data flowed from Head Office to Branches. These are configured in Replication Rules . Refer to Figure 2.
    1. Location Code - Add the locations for the server.
    2. Active - Tick this flag to make the location active.

View Server Status

  1. Queue Details - Shows the number of records at different stages in replication.
  2. Status - Shows last connection time.

Rules - The rules tab shows a list of replication rules that is active for the server.

Figure 1 : Replication Server
 

Figure 2: Locations