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 AnywhereMany 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