II Replication Design for SQL Remote

71

6

Principles of SQL Remote Design

73

 

Design overview

74

 

How statements are replicated

78

 

How data types are replicated

83

 

Who gets what?

86

 

Replication errors and conflicts

88

7

SQL Remote Design for Adaptive Server Anywhere

91

 

Design overview

92

 

Publishing data

93

 

Publication design for Adaptive Server Anywhere

102

 

Partitioning tables that do not contain the subscription ex-

 

 

pression

105

 

Sharing rows among several subscriptions

112

 

Managing conflicts

120

 

Ensuring unique primary keys

129

 

Creating subscriptions

139

8

SQL Remote Design for Adaptive Server Enterprise

141

 

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

III

SQL Remote Administration

183

9

Deploying and Synchronizing Databases

185

 

Deployment overview

186

 

Test before deployment

187

 

Synchronizing databases

189

 

Using the extraction utility

191

 

Synchronizing data over a message system

198

10

SQL Remote Administration

199

 

Management overview

200

 

Managing SQL Remote permissions

201

 

Using message types

210

iv

Page 4
Image 4
Sybase DC38133-01-0902-01 manual Principles of SQL Remote Design, SQL Remote Design for Adaptive Server Anywhere