User's Manual

CHAPTER 7
SQL Remote Design for Adaptive Server
Anywhere
About this chapter This chapter describes how to design a SQL Remote installation when the
consolidated database is an Adaptive Server Anywhere database.
Similar material for Adaptive Server Enterprise
Many of the principles of publication design are the same for Adaptive
Server Anywhere and Adaptive Server Enterprise, but there are differences
in commands and capabilities. There is a large overlap between this chapter
and the corresponding chapter for Adaptive Server Enterprise users, “SQL
Remote Design for Adaptive Server Enterprise” on page 141.
Contents
Topic: page
Design overview 92
Publishing data 93
Publication design for Adaptive Server Anywhere 102
Partitioning tables that do not contain the subscription expression 105
Sharing rows among several subscriptions 112
Managing conflicts 120
Ensuring unique primary keys 129
Creating subscriptions 139
91