Contents
About This Manual ix
SQL AnywhereStudio documentation . . . . . . . . . . . . . x
Documentation conventions . . . . . . . . . . . . . . . . . . . xiii
The AdaptiveServer Anywheresample database. . . . . . . xv
Finding outmore andproviding feedback . . . . . . . . . . . xvi

I Introduction to SQL Remote 1

1 Welcome to SQL Remote 3
AboutSQLRemote ....................... 4
Aboutthismanual ........................ 5
2 SQL Remote Concepts 7
SQL Remotecomponents . . . . . . . . . . . . . . . . . . . . 8
Publications andsubscriptions . . . . . . . . . . . . . . . . . 11
SQLRemotefeatures ...................... 13
Some sampleinstallations . . . . . . . . . . . . . . . . . . . . 15
3 Setting Up SQL Remote 19
Setupoverview.......................... 20
Preparing yourAdaptive ServerEnterprise server . . . . . . 21
Upgrading SQL Remote forAdaptive Server Enterpr ise . . . 25
Uninstalling SQLRemote . . . . . . . . . . . . . . . . . . . . 26
4 Tutorials for Adaptive Server Anywhere Users 27
Introduction ............................ 28
Tutorial:Adaptive Server Anywhere replication using Sybase
Central ........................... 32
Tutorial:Adaptive Server Anywhere replication using Interac-
tive SQLand dbxtract . . . . . . . . . . . . . . . . . . . 40
Start replicatingdata . . . . . . . . . . . . . . . . . . . . . . . 47
Asamplepublication....................... 51
5 A Tutorial for Adaptive Server Enterprise Users 53
Introduction ............................ 54
Tutorial:Adaptive Server Enterprisereplication . . . . . . . . 57
Start replicatingdata . . . . . . . . . . . . . . . . . . . . . . . 66
iii