CHAPTER 8

SQL Remote Design for Adaptive Server Enterprise

About this chapter

Contents

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 .

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

Page 159
Image 159
Sybase DC38133-01-0902-01 manual SQL Remote Design for Adaptive Server Enterprise, 141