Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Remote » Creating SQL Remote systems

 

Using overlap partitions

Data partitioning overlaps when the remote databases share data. For example, sales representatives share customers amongst themselves.

Suppose three tables store information about the interactions between sales representatives and customers: Customers, Policy, and SalesReps. Each sales representative sells to several customers, and some customers deal with more than one sales representative. The Policy table has foreign keys to both the Customers and SalesReps tables. There is a many-to-many relationship between Customers and SalesReps.

The Policy table has foreign keys to both the Customers and SalesReps tables.
 Description of Customers, Policy, and SalesReps tables
 Partitioning data
 Multiple-valued subqueries in publications

Maintaining referential integrity when reassigning rows among subscribers
Using the subscribe_by_remote option with many-to-many relationships