Synchronizing One Database with Multiple Syncs
Top  Previous  Next

In large databases (greater than 10 users), you may want to subdivide the database into multiple sync processes. This is not advised to do on small syncs but worthwhile on an installation that has a large number of users.

This option is only available on 123 Sync V18.0.2.10 or later.

Example.

Assume you have a 50 user installation and you want to sync the database using 2 sync processes.

Here's the steps:
1.Purchase 2 25-User licenses since you will be activating each one of them for 25 users.  
2.Create Two Windows Accounts: You need a Windows user accounts for each 25-User batch that you want to sync. In this example we need two windows user accounts namely Users1to25 and Users26to50.  
3.Setup Users1to25 to sync. Login to user Users1to25 and setup 123 Sync for the users 1 thorough 25, including the windows service. Setup 123 Sync as you would do normally.  
4.Activate the license for the 25 users. You are now ready to sync the first batch of users  
5.Logout of Users1to25  
6.Login into Users26to50 user.  
7.Start 123 Sync and setup the remaining users, namely user 26 through 50.  
8.On the 123 Sync Menu, run Tools->Advanced->Tools->Create Parallel Processing Executable  
9.Restart 123 Sync  
10.Activate the second 25 User License.  
11.You can now run 123 Sync on Users26to50  

A couple of things to look for:
·Each license should be equal or larger that the number of enabled users you want to sync per process. If you want to subdivide the 50 user sync into 5 processes of 10 users each, you need 5 123 Sync licenses.  
·Each Sync Username has it's own executable. The Create Parallel Processing Executable action creates a set of executables that are unique for that user.  
The windows service name is named after the executable version that you are running. To find out the name of the service specific to your username, go to Tools->Background Processing->123 Sync Windows Service->Name of Sync Service  

The System Tray Background Process
If you are running the sync from the system tray, there is no need to make any further modifications.

Creating Windows Services to sync each database
If you want to create a windows service that runs in the background, do the following:
·In 123 Sync, go to the Tools->Background Processing->123 Sync Windows Service->Register 123 Sync Service  
·Consequently, go to the windows service 123 Sync just created and set the username/password. If you are logged in as Users26to50, set the Users26to50 username and passwords.