Article: KB-SITESYNC

Module: WTX_SiteSync.exe

Build: 9.0.0.467

Summary

The WordTricks site synchronization is typically a server to server process that synchronizes the WordTricks files and databases between multiple site locations within a single organization. Sites can be in remote locations or, in rare circumstances, separate sites/servers within the same building. The primary purpose of the site synchronization is to eliminate the need to manually copy data from site to site.

How does it work?

The WTX master site is the main location in your organization from where the WordTricks master database and master files originate, however, information within the firm database is synchronized in both directions.

Each site is given a unique number designated by the WordTricks administrator. You can at any time add data to

Database Definitions

The table used in the synchronization process is called SiteServices. The SiteServices table resides on each site involved in the synchronization.

The following are field definitions for the SiteServices table:

SiteNumber - This is a unique number associated with each location in your firm/company.
Description - This field is a description of the site.
IsMaster - This filed determines which of the sites in your organization is the master. There can only be one master site.
IsActive - This fiels determins if the site participates in the synchronization process (a means to disable a site).
UncPath - Path to the WordTricks network directory on the site server.
DataProvider - The actual provider string used within the site syncronization (jet/SQL connection).

You should add all the sites that you know you will be involved in the site synchronization regardless of the fact that all the sites involved are not installed properly and not ready to participate in the synchronization process. Make sure you set IsActive to False if the site is not ready for the synchronization. When you are confident that a site is ready for synchronization set the IsActive to True.

Note: Because of the stability over LAN's and WAN's WordTricks recomends using a SQL server as the master site database, however, MSDE and Access database will work.

*WordTricks Forms

The site sync services, as of the publication of this article, does not synchronize WordTricks Forms Library templates nor database information axxociated with forms.