Data Replication with SQL Remote
PART 2. Replication Design for SQL Remote

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.

  Design overview
  Creating publications
  Publication design for Adaptive Server Enterprise
  Partitioning tables that do not contain the subscription column
  Sharing rows among several subscriptions
  Managing conflicts
  Ensuring unique primary keys
  Creating subscriptions