Filter
Top Products
CHAPTER 8
SQL Remote Design for Adaptive Server
Enterprise
About this chapter This chapter describes how to design a SQL Remote installation when the
consolidated database is at an Adaptive Server Enterprise server.
Similar material for Adaptive Server Anywhere
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 Anywhere users, “SQL
Remote Design for Adaptive Server Anywhere” on page 91.
Contents
Topic: page
Design overview 142
Creating publications 143
Publication design for Adaptive Server Enterprise 147
Partitioning tables that do not contain the subscription column 149
Sharing rows among several subscriptions 157
Managing conflicts 165
Ensuring unique primary keys 175
Creating subscriptions 181
141