User's Manual

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