Synchroning Multiple Databases on One Machine

Synchroning Multiple Databases on One Machine

Top Previous Next

In some cases, you want to run 123 Sync on a single machine but sync or integrate two or more Act! databases. We see that a lot with Terminal Servers and cloud servers.
123 Sync can sync multiple databases in one machine but it takes a little bit of manual setup.

The 123 Sync sync engine has a trip switch that will not allow it to run in multiple instances on a machine. The reason is that you don't want to have duplicate synchronizations running concurrently. That can happen if Act! is slow or the Exchange connection slows down, etc.. So for safety, if 123 Sync sees another sync process running, it just exits. Since you will be synchronizing two different databases on the same machine, the key is to establish the second sync as an independent sync.

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

Example.
Assume DatabaseA and DatabaseB need to be synched on the same machine.
Here's the steps:

Create Two Windows Accounts: You need a Windows user accounts for each database that you want to sync. In this example we need two windows user accounts namely DatabaseA and DatabaseB.

Setup DatabaseA to sync. Login to user DatabaseA and setup 123 Sync for the user DatabaseA, including the windows service. Setup 123 Sync as you would do normally.

Logout of DatabaseA

Login into DatabaseB user.

Start 123 Sync and setup Databaseb to sync without enabling the windows sync service (if you are going to use windows services).

On the 123 Sync Menu, run Tools->Advanced->Tools->Create Parallel Processing Executable

Restart 123 Sync

You can now run 123 Sync on DatabaseB

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 DatabaseB, set the DatabaseB username and passwords.