1. SymmetricDS Communitity Edition

1.1. Linux

1.1.1. Installation

  • Install Java.

  • Install PostgreSQL 13.

  • Create a db-sym database with a table1 table.

    • Enter the following commands at a Command Line.

      psql --dbname postgres --command '\du+'
createdb --encoding UTF8 --owner smru db-sym
psql --dbname db-sym --command "\dt+;"
psql --dbname db-sym --command "DROP TABLE table1;"
psql --dbname db-sym --command "CREATE TABLE table1(x INT PRIMARY KEY, y INT);"
psql --dbname db-sym --command "INSERT INTO table1 VALUES(1, 11);"
psql --dbname db-sym --command "SELECT * FROM table1;"

  • Enter the following commands at a Command Line.

    cd /opt
sudo wget https://sourceforge.net/projects/symmetricds/files/symmetricds/symmetricds-3.12/symmetric-server-3.12.11.zip
sudo unzip symmetric-server-3.12.11.zip
sudo ln -s /opt/symmetric-server-3.12.11 /opt/symmetric-server
cd symmetric-server
sudo bin/sym_service install
sudo bin/sym_service status
sudo bin/sym_service start
sudo bin/sym_service status

1.1.2. Configuration

1.1.2.1. HQ Step 1

  • Create the /opt/symmetric-server/engines/master-hq.properties file with the following contents.

  • Make sure that the db.password= line uses the level 2 password.

    engine.name=master-hq
external.id=hq
group.id=master

sync.url=http://vbox-deb-hq:31415/sync/master-hq
registration.url=

db.url=jdbc:postgresql://vbox-deb-hq/db-sym
db.driver=org.postgresql.Driver
db.user=smru
db.password=********

auto.registration=true
initial.load.create.first=true

  • Enter the following commands at a Command Line.

    # sudo chmod 640 /opt/symmetric-server/engines/master-hq.properties     ???

cd /opt/symmetric-server

sudo bin/sym_service status
sudo bin/sym_service stop
sudo bin/sym_service status

sudo bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo bin/sym_service status
sudo bin/sym_service start
sudo bin/sym_service status

psql --dbname db-sym --command "\dt+;"
psql --dbname db-sym --command "SELECT * FROM sym_node;"
psql --dbname db-sym --command "SELECT * FROM sym_node_group;"
psql --dbname db-sym --command "SELECT * FROM sym_node_security;"
psql --dbname db-sym --command "SELECT * FROM sym_node_identity;"
psql --dbname db-sym --command "SELECT * FROM sym_node_group_link;"
psql --dbname db-sym --command "SELECT * FROM sym_node_host;"
psql --dbname db-sym --command "SELECT * FROM sym_router;"
psql --dbname db-sym --command "SELECT * FROM sym_channel;"
psql --dbname db-sym --command "SELECT * FROM sym_trigger;"
psql --dbname db-sym --command "SELECT * FROM sym_trigger_router;"
1.1.2.2. BO Step 1

  • Create the /opt/symmetric-server/engines/master-bo.properties file with the following contents.

  • Make sure that the db.password= line uses the level 2 password.

    engine.name=master-bo
external.id=bo
group.id=master

sync.url=http://vbox-deb-bo:31415/sync/master-bo
registration.url=http://vbox-deb-hq:31415/sync/master-hq

db.url=jdbc:postgresql://vbox-deb-bo/db-sym
db.driver=org.postgresql.Driver
db.user=smru
db.password=********

  • Enter the following commands at a Command Line.

    # sudo chmod 640 /opt/symmetric-server/engines/master-bo.properties     ???

cd /opt/symmetric-server

psql --dbname db-sym --command "\dt+;"

sudo bin/sym_service status
sudo bin/sym_service stop
sudo bin/sym_service status

sudo bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo bin/sym_service status
sudo bin/sym_service start
sudo bin/sym_service status

psql --dbname db-sym --command "\dt+;"
psql --dbname db-sym --command "SELECT * FROM sym_node;"
psql --dbname db-sym --command "SELECT * FROM sym_node_group;"
psql --dbname db-sym --command "SELECT * FROM sym_node_security;"
psql --dbname db-sym --command "SELECT * FROM sym_node_identity;"
psql --dbname db-sym --command "SELECT * FROM sym_node_group_link;"
psql --dbname db-sym --command "SELECT * FROM sym_node_host;"
psql --dbname db-sym --command "SELECT * FROM sym_router;"
psql --dbname db-sym --command "SELECT * FROM sym_channel;"
psql --dbname db-sym --command "SELECT * FROM sym_trigger;"
psql --dbname db-sym --command "SELECT * FROM sym_trigger_router;"
1.1.2.3. HQ Step 2

  • Create the /tmp/insert_hq.sql file with the following contents.

    INSERT INTO sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action, sync_config_enabled) VALUES ('master', 'master', 'P', '1');

  • Enter the following commands at a Command Line.

    cd /opt/symmetric-server
sudo bin/dbimport --engine master-hq /tmp/insert_hq.sql

psql --dbname db-sym --command "SELECT * FROM sym_node_group_link;"
1.1.2.4. BO Step 2

  • Enter the following commands at a Command Line.

    cd /opt/symmetric-server

psql --dbname db-sym --command "\dt+;"

sudo bin/sym_service status
sudo bin/sym_service stop
sudo bin/sym_service status

sudo bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo bin/sym_service status
sudo bin/sym_service start
sudo bin/sym_service status

psql --dbname db-sym --command "\dt+;"
1.1.2.5. HQ Step 3

  • Create the /tmp/insert_hq.sql file with the following contents.

    INSERT INTO sym_router (router_id,target_schema_name,source_node_group_id,target_node_group_id,sync_on_update,sync_on_insert,sync_on_delete,create_time,last_update_by,last_update_time) VALUES ('master_2_master','public','master','master',1,1,1,current_timestamp,'smru',current_timestamp);
INSERT INTO sym_trigger (trigger_id,source_schema_name,source_table_name,channel_id,sync_on_update,sync_on_insert,sync_on_delete,sync_on_update_condition,sync_on_insert_condition,sync_on_delete_condition,create_time,last_update_by,last_update_time) VALUES ('public.table1','public','table1','default',1,1,1,'1=1','1=1','1=1',current_timestamp,'smru',current_timestamp);
INSERT INTO sym_trigger_router (trigger_id,router_id,enabled,initial_load_order,create_time,last_update_by,last_update_time) VALUES ('public.table1','master_2_master',1,50,current_timestamp,'smru',current_timestamp);

  • Enter the following commands at a Command Line.

    cd /opt/symmetric-server
sudo bin/dbimport --engine master-hq /tmp/insert_hq.sql

psql --dbname db-sym --command "SELECT * FROM sym_router;"
psql --dbname db-sym --command "SELECT * FROM sym_trigger;"
psql --dbname db-sym --command "SELECT * FROM sym_trigger_router;"

sudo bin/sym_service status
sudo bin/sym_service stop
sudo bin/sym_service status

sudo bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo bin/sym_service status
sudo bin/sym_service start
sudo bin/sym_service status
1.1.2.6. BO Step 3

  • Enter the following commands at a Command Line.

    cd /opt/symmetric-server

sudo bin/sym_service status
sudo bin/sym_service stop
sudo bin/sym_service status

sudo bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo bin/sym_service status
sudo bin/sym_service start
sudo bin/sym_service status

psql --dbname db-sym --command "\dt+;"
psql --dbname db-sym --command "SELECT * FROM sym_node;"
psql --dbname db-sym --command "SELECT * FROM sym_node_group;"
psql --dbname db-sym --command "SELECT * FROM sym_node_security;"
psql --dbname db-sym --command "SELECT * FROM sym_node_identity;"
psql --dbname db-sym --command "SELECT * FROM sym_node_group_link;"
psql --dbname db-sym --command "SELECT * FROM sym_node_host;"
psql --dbname db-sym --command "SELECT * FROM sym_router;"
psql --dbname db-sym --command "SELECT * FROM sym_channel;"
psql --dbname db-sym --command "SELECT * FROM sym_trigger;"
psql --dbname db-sym --command "SELECT * FROM sym_trigger_router;"
1.1.2.7. Final Step

  • Restart the HQ computer.

  • Restart the BO computer.

1.1.3. ANC Database

  • Make a backup of the anc-entire database on the tbhf-anc-mrm server.

    sudo /usr/local/sbin/smru-db-clinic-backup /tmp tbhf-anc-mrm anc-entire
ls -al /tmp/YYYY-MM-DD-tbhf-anc-mrm-anc-entire.backup

  • Restore the backup of the anc-entire database on the HQ computer.

  • Restore the backup of the anc-entire database on the BO# computers.

  • Copy the anc-entire database to a new anc-db database.

    # Add anc role to PostgreSQL database server.
sudo su - postgres -c 'createuser --no-superuser --no-createdb --no-createrole --login --no-inherit --pwprompt anc'
psql --dbname postgres --command '\du+'

# Copy backup file from tbhf-anc-mrm server.
scp -p smru@tbhf-anc-mrm:/tmp/YYYY-MM-DD-tbhf-anc-mrm-anc-entire.backup .

# Delete and create database.
dropdb anc-entire
createdb --encoding UTF8 --owner anc anc-entire

# Restore database.
pg_restore --dbname anc-entire --schema=public --single-transaction YYYY-MM-DD-tbhf-anc-mrm-anc-entire.backup
smru-db-copy anc-entire anc-db

# List databases.
psql --list
1.1.3.1. Master HQ Step 1

  • Create the /opt/symmetric-server/engines/anc-engine.properties file with the following contents.

  • Make sure that the db.password= line uses the level 2 password.

    engine.name=anc-engine
external.id=hq
group.id=anc-group

sync.url=http://vbox-deb-hq:31415/sync/anc-engine
registration.url=

db.url=jdbc:postgresql://vbox-deb-hq/anc-db
db.driver=org.postgresql.Driver
db.user=smru
db.password=********

auto.registration=true
initial.load.create.first=true

  • Enter the following commands at a Command Line.

    # sudo chmod 640 /opt/symmetric-server/engines/anc.properties   ???

sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service stop
sudo /opt/symmetric-server/bin/sym_service status
psql --dbname anc-db --command "\dt+;"

sudo /opt/symmetric-server/bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service start
sudo /opt/symmetric-server/bin/sym_service status
psql --dbname anc-db --command "\dt+;"

psql --dbname anc-db --command "SELECT * FROM sym_node;"
psql --dbname anc-db --command "SELECT * FROM sym_node_group;"
psql --dbname anc-db --command "SELECT * FROM sym_node_security;"
psql --dbname anc-db --command "SELECT * FROM sym_node_identity;"
psql --dbname anc-db --command "SELECT * FROM sym_node_group_link;"
psql --dbname anc-db --command "SELECT * FROM sym_node_host;"
psql --dbname anc-db --command "SELECT * FROM sym_router;"
psql --dbname anc-db --command "SELECT * FROM sym_channel;"
psql --dbname anc-db --command "SELECT * FROM sym_trigger;"
psql --dbname anc-db --command "SELECT * FROM sym_trigger_router;"
1.1.3.2. Master BO# Step 1

  • Create the /opt/symmetric-server/engines/anc-engine.properties file with the following contents.

  • Make sure that the db.password= line uses the level 2 password.

    engine.name=anc-engine
external.id=bo#
group.id=anc-group

sync.url=http://vbox-deb-bo#:31415/sync/anc-engine
registration.url=http://vbox-deb-hq:31415/sync/anc-engine

db.url=jdbc:postgresql://vbox-deb-bo#/anc-db
db.driver=org.postgresql.Driver
db.user=smru
db.password=********

  • Enter the following commands at a Command Line.

    # sudo chmod 640 /opt/symmetric-server/engines/anc.properties     ???

sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service stop
sudo /opt/symmetric-server/bin/sym_service status
psql --dbname anc-db --command "\dt+;"

sudo /opt/symmetric-server/bin/sym
# Wait for the "Successfully registered node" message.
# Press Ctrl+C to stop the SymmetricDS Server.

sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service start
sudo /opt/symmetric-server/bin/sym_service status
psql --dbname anc-db --command "\dt+;"
1.1.3.3. Master HQ Step 2

  • Create the /tmp/insert_hq.sql file with the following contents.

    INSERT INTO sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action, sync_config_enabled) VALUES ('anc-group', 'anc-group', 'P', '1');

  • Enter the following commands at a Command Line.

    sudo /opt/symmetric-server/bin/dbimport --engine anc-engine /tmp/insert_hq.sql
psql --dbname anc-db --command "SELECT * FROM sym_node_group_link;"
1.1.3.4. Master BO# Step 2

  • Enter the following commands at a Command Line.

    sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service stop
sudo /opt/symmetric-server/bin/sym_service status
psql --dbname anc-db --command "SELECT * FROM sym_node_group;"
psql --dbname anc-db --command "SELECT * FROM sym_node_group_link;"

sudo /opt/symmetric-server/bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service start
sudo /opt/symmetric-server/bin/sym_service status
psql --dbname anc-db --command "SELECT * FROM sym_node_group;"
psql --dbname anc-db --command "SELECT * FROM sym_node_group_link;"
1.1.3.5. Master HQ Step 3

  • Enter the following commands at a Command Line.

    scp -p smru@tbhf-anc-mrm:github/git/delta-software-labs/ANC-Application/symmetricds/insert-anc-tables.sql .
sudo /opt/symmetric-server/bin/dbimport --engine anc-engine insert-anc-tables.sql

psql --dbname anc-db --command "SELECT * FROM sym_router;"
psql --dbname anc-db --command "SELECT * FROM sym_trigger;"
psql --dbname anc-db --command "SELECT * FROM sym_trigger_router;"

sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service stop
sudo /opt/symmetric-server/bin/sym_service status

sudo /opt/symmetric-server/bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service start
sudo /opt/symmetric-server/bin/sym_service status
1.1.3.6. Master BO# Step 3

  • Enter the following commands at a Command Line.

    sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service stop
sudo /opt/symmetric-server/bin/sym_service status

sudo /opt/symmetric-server/bin/sym
# Press Ctrl+C to stop the SymmetricDS Server.

sudo /opt/symmetric-server/bin/sym_service status
sudo /opt/symmetric-server/bin/sym_service start
sudo /opt/symmetric-server/bin/sym_service status

psql --dbname anc-db --command "\dt+;"
psql --dbname anc-db --command "SELECT * FROM sym_node;"
psql --dbname anc-db --command "SELECT * FROM sym_node_group;"
psql --dbname anc-db --command "SELECT * FROM sym_node_security;"
psql --dbname anc-db --command "SELECT * FROM sym_node_identity;"
psql --dbname anc-db --command "SELECT * FROM sym_node_group_link;"
psql --dbname anc-db --command "SELECT * FROM sym_node_host;"
psql --dbname anc-db --command "SELECT * FROM sym_router;"
psql --dbname anc-db --command "SELECT * FROM sym_channel;"
psql --dbname anc-db --command "SELECT * FROM sym_trigger;"
psql --dbname anc-db --command "SELECT * FROM sym_trigger_router;"
1.1.3.7. Final Steps

  • Change owner of all sym_* tables to anc on HQ computer.

  • Change owner of all sym_* tables to anc on BO# computers.

    scp -p smru@tbhf-anc-mrm:github/git/delta-software-labs/ANC-Application/symmetricds/change_owner_of_symmetricds_objects.sql .
psql --dbname anc-db --command '\ds+'
psql --dbname anc-db --command '\dt+'
PSQLOPTIONS="--no-psqlrc --pset pager=off --quiet --set ON_ERROR_STOP=1 --single-transaction"
psql $PSQLOPTIONS --dbname anc-db --file change_owner_sym_tables.sql
psql --dbname anc-db --command '\ds+'
psql --dbname anc-db --command '\dt+'

  • Restart the HQ computer.

  • Restart the BO# computers.

BOOKMARK

1.1.3.8. Encrypt Node Password

  • Enter the following commands at a Command Line.

  • Make sure that the encrypt-text line uses the level 2 password.

    sudo /opt/symmetric-server/bin/symadmin -e m-hq encrypt-text '********'

  • Copy the enc:xxxxxxxxxxxxxxxxxxxx== and past it to db.password field in /opt/symmetric-server/engines/m-hq.properties file.

1.1.3.9. Useful Commands
psql --dbname anc-entire --command "SELECT * FROM sym_node;"
psql --dbname anc-entire --command "UPDATE sym_node SET sync_url='http://vbox-deb-hq:31415/sync/anc' WHERE node_id='hq';"
psql --dbname anc-entire --command "SELECT * FROM sym_node;"

# SELECT * FROM "ANC" WHERE "ANC_code"='MKT-01603';
# UPDATE "ANC" SET "Postit"='HQtest' WHERE "ANC_code"='MKT-01603';
# SELECT * FROM "ANC" WHERE "ANC_code"='MKT-01603';

# SELECT * FROM "tblUrineStickTest" WHERE "ANC_code"='MKT-01603';
# UPDATE "tblUrineStickTest" SET "pH"=9 WHERE "ANC_code"='MKT-01603';
# SELECT * FROM "tblUrineStickTest" WHERE "ANC_code"='MKT-01603';


# SELECT * FROM "tblWeeklyExam" WHERE "ANC_code"='MKT-01603';
# UPDATE "tblWeeklyExam" SET "EGA"=99 WHERE "ANC_code"='MKT-01603';
# SELECT * FROM "tblWeeklyExam" WHERE "ANC_code"='MKT-01603';

1.2. Windows

2. SymmetricDS Professional Edition

2.1. Linux

2.2. Windows

2.2.1. Installation

  • Run the symmetric-pro-3.12.6-setup.jar file with administrative privileges.

  • Click Next.

  • Choose I accept the terms of this license agreement.

  • Click Next.

  • Choose Install new software.

  • Click Next.

    C:\SymmetricDS-Pro

  • Click Next.

  • Click OK to confirm.

    ■ Main Installation
■ SQL-Server Driver
■ PostgreSQL Driver
■ MySQL Driver
■ Oracle Driver
■ Documentation

  • Click Next.

  • Check Install service to run automatically.

    ■ Install service to run automatically
Service Name            SymmetricDS
■ Run server after installing

  • Click Next.

    Web console and data synchronization
■ Enable HTTPS
■ Enable HTTPS/2
■ Enable HTTP
HTTPS Port      31417
HTTP Port       31415

Third party management tools (optional)
□ Enable JMX

  • Click Next.

    How much memory to use for the server?
○ Small - 256 MB - sync small data with few nodes
● Medium - 1024 MB - sync moderate data with multiple nodes
○ Large - 4096 MB - sync large data with many nodes
○ Other

  • Click Next.

    Disk space is used for processing change data temporarily.
● Default location
○ Use a different location

Staging options:
■ Compress to conserve space
■ Encrypt to protect data

  • Click Next.

  • Click Next.

  • Wait for the installation to finish.

  • Click Next.

    ■ Create shortcuts in the Start Menu
□ Create additional shortcuts on the desktop

(Default)                       create shortcut for:
                                ○ current user
                                ● all users

  • Click Next.

  • Wait for the installation to finish.

  • Click Next.

  • Uncheck Open SymmetricDS Pro control center.

  • Click Done.

2.2.2. HQ Setup

  • Start pgAdmin 4 to create the db-hq database.

    • Type the master password (level 1) and click OK.

    • Expand Servers.

    • Type the postgres password (level 2) and click OK.

    • Expand Databases.

    • Right-click Databases and select Create > Database.

    • Select the General tab.

    • Type db-hq in the Database field.

    • Click Save.

    • Expand Databases > db-hq > Schemas > public > tables.

    • Right-click Tables and select Create > Table.

    • Select the General tab.

    • Type table1 in the Name field.

    • Click Save.

    • Expand Databases > db-hq > Schemas > public > tables > table1 > columns.

    • Right-click Columns and select Create > Column.

    • Select the General tab.

    • Type x in the Name field.

    • Select the Definition tab.

    • Select integer in the Data type field.

    • Click Save.

    • Right-click Columns and select Create > Column.

    • Select the General tab.

    • Type y in the Name field.

    • Select the Definition tab.

    • Select integer in the Data type field.

    • Click Save.

  • Close pgAdmin 4.

  • Start SymmetricDS Pro Control Center.

  • Click Open Web Console.

  • Click the Master icon.

Database        PostgreSQL
Mode            Trigger-based capture
Url             jdbc:postgresql://localhost/db-hq?protocolVersion=3&stringtype=unspecified&socketTimeout=300&tcpKeepAlive=true
User id         postgres
Password        ********        (level 2)

  • Click Test.

  • Close the test popup message.

  • Click Next.

  • Click Next.

  • Select Master to Master.

  • Click Next.

    Sync URL        http://WIN10-HQ:31415/sync/master-1

  • Click Next.

    □ Enable Cluster Locks

  • Click Next.

    User Id                 admin
Password                ********        (SymmetricDS admin password)
Confirm Password        ********        (SymmetricDS admin password)

  • Click Next.

  • Click Finish.

  • Wait for node installation to finish.

    User Id                 admin
Password                ********        (SymmetricDS admin password)
Node                    master-1

  • Click Login.

  • Click Install License.

  • Paste the license key in the box.

  • Click Save.

  • Click Next to enter the Quick Configuration Wizard.

  • Select master pushes to master.

  • Click Next.

  • Select the table1 table.

  • Click the > button.

  • Click Next.

  • Click Finish.

  • Click the Remote Node icon.

Remote Node Setup Instructions

1 Install SymmetricDS on the remote machine.
2 Open the web console for the remote machine and setup the new node.
3 When prompted during setup, use the following Registration URL:

        http://WIN10-HQ:31415/sync/master-hq

  • Click Turn On Auto Registration.

  • Click Finish.

  • Select admin > Logout.

  • Close SymmetricDS Pro Control Center.

  • Start pgAdmin 4.

  • Expand Databases > db-hq > Schemas > public > tables.

  • Close pgAdmin 4.

2.2.3. BO Setup

  • Start pgAdmin 4 to create the db-bo database.

    • Type the master password (level 1) and click OK.

    • Expand Servers.

    • Type the postgres password (level 2) and click OK.

    • Expand Databases.

    • Right-click Databases and select Create > Database.

    • Select the General tab.

    • Type db-bo in the Database field.

    • Click Save.

    • Expand Databases > db-bo > Schemas > public > tables.

  • Close pgAdmin 4.

  • Start SymmetricDS Pro Control Center.

  • Click Open Web Console.

  • Click the Node icon.

Database        PostgreSQL
Mode            Trigger-based capture
Url             jdbc:postgresql://localhost/db-bo?protocolVersion=3&stringtype=unspecified&socketTimeout=300&tcpKeepAlive=true
User id         postgres
Password        ********        (level 2)

  • Click Test.

  • Close the test popup message.

  • Click Next.

  • Click Next.

    Registration URL        http://WIN10-HQ:31415/sync/master-1

  • Click Next.

  • Click Cancel when the Could not contact the registration server using the URL provided message pops up.

    • Turn off Windows Defender Firewall on WIN10-HQ.

    • Turn off Windows Defender Firewall on WIN10-BO.

  • Click Next to try again.

  • Select master for the Node Group.

  • Click Next.

  • Type BO-1 for the External ID.

  • Click Next.

    Sync URL        http://WIN10-BO:31415/sync/master-BO-1

  • Click Next.

    □ Enable Cluster Locks

  • Click Next.

  • Click Finish.

  • Wait for node installation to finish.

    User Id                 admin
Password                ********        (SymmetricDS admin password)
Node                    master-BO-1

  • Click Login.

  • Wait for the synchronization to finish.

  • Select admin > Logout.

  • Close SymmetricDS Pro Control Center.

2.2.4. HQ Setup 2

  • Start SymmetricDS Pro Control Center.

  • Click Open Web Console.

  • Click Next to enter the Data Load Wizard.

    * send data to

+ BO-1  master  PostgreSQL      3.12.6

  • Click Next.

    *How many tables would you like to load?*
. All Tables
* Select Specific Tables
. All Tables for channel

*What should be done before loading the target data?*
. Nothing, just send the data.
* Create table(s) or alter them to match the source.
. Purge data in the table(s). (initial load delete or delete all)
. Truncate the table(s).
. Run custom SQL for each table.

  • Click Next.

  • Check public | table1.

  • Click Next.

  • Click Finish.

  • Wait for the outgoing loads to finish.

2.2.5. BO Setup 2

  • Start pgAdmin 4.

  • Expand Databases > db-bo > Schemas > public > tables.

  • Verify that table1 has been synced.

  • Close pgAdmin 4.