The table structure I have:
tbl_customer (customer_id, first_name, last_name)
tbl_customer_details (customer_id, location_id, details)
1) When syncing Master to Client Nodes, how do I sync tbl_customer where data is in a certain location_id? As you can see from our structure, in SQL we have to join tbl_customer to tbl_customer_details on customer_id where location_id = X
How can I tell SymmetricDS to sync accordingly and how do I designate each client node with a location ID?
2) Is it possible to sync from a view on client node to a table on master or can it only be from table to table?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I am trying out SymmetricDS and very new at this. There are two questions I have:
Master
Client Node 1 (location_id = 001)
Client Node 2 (location_id = 002)
The table structure I have:
tbl_customer (customer_id, first_name, last_name)
tbl_customer_details (customer_id, location_id, details)
1) When syncing Master to Client Nodes, how do I sync tbl_customer where data is in a certain location_id? As you can see from our structure, in SQL we have to join tbl_customer to tbl_customer_details on customer_id where location_id = X
How can I tell SymmetricDS to sync accordingly and how do I designate each client node with a location ID?
2) Is it possible to sync from a view on client node to a table on master or can it only be from table to table?