Replication

For System Administrators

Database replication is a powerful feature of TeamLeader that allows remote users to work offline and synchronize later. Using Replication, each user may use a local copy (replica) of the TeamLeader database. We suggest that the TeamLeader Administrator set up a hub replica system using Microsoft Replication Manager. The design master should be associated with the hub, but not set up to replicate automatically. Further, any customizations to TeamLeader that result in the creation of additional tables will require that the tables be added in the design master and then changes propagated though the replica network.

With an HTTP connection, TeamLeader will synchronize the local database with the hub replica so all users will have access to the same up-to-date information.

Replication is supported by a utility called TLREP.EXE, which is controlled by the REPLICA table in the TeamLeader database. To set up replication, MS Access is required to modify the REPLICA table directly as follows:

·   REPLICA_LOCATION - Specify the web address of the mapped replica

·   USER_ID - Specify the ID of the person for which you would like replication to be activated. If left blank, replication will occur for all users.

·   IMPORT - Should data be imported from the REPLICA?

·   EXPORT - Should data be exported to the REPLICA?