SQL Remote User's Guide
SQL Remote Design for Adaptive Server Enterprise
Sharing rows among several subscriptions
The Policy database illustrates why and how to partition tables when there is a many-to-many relationship in the database.
Here is a simple database that illustrates the problem.
The Policy table has a row for each of a set of policies. Each policy is drawn up for a customer by a particular sales representative. There is a many-to-many relationship between customers and sales representatives, and there may be several policies drawn up between a particular rep/customer pair.
Any row in the Customer table may need to be shared with none, one, or several sales representatives.
Solving the problem
The publication