User's Manual

Contents
About This Manual ix
SQL Anywhere Studio documentation . . . . . . . . . . . . . x
Documentation conventions . . . . . . . . . . . . . . . . . . . xiii
The Adaptive Server Anywhere sample database . . . . . . . xv
Finding out more and providing feedback . . . . . . . . . . . xvi
I Introduction to SQL Remote 1
1 Welcome to SQL Remote 3
About SQL Remote . . . . . . . . . . . . . . . . . . . . . . . 4
About this manual . . . . . . . . . . . . . . . . . . . . . . . . 5
2 SQL Remote Concepts 7
SQL Remote components . . . . . . . . . . . . . . . . . . . . 8
Publications and subscriptions . . . . . . . . . . . . . . . . . 11
SQL Remote features . . . . . . . . . . . . . . . . . . . . . . 13
Some sample installations . . . . . . . . . . . . . . . . . . . . 15
3 Setting Up SQL Remote 19
Setup overview . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Preparing your Adaptive Server Enterprise server . . . . . . 21
Upgrading SQL Remote for Adaptive Server Enterprise . . . 25
Uninstalling SQL Remote . . . . . . . . . . . . . . . . . . . . 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 SQL and dbxtract . . . . . . . . . . . . . . . . . . . 40
Start replicating data . . . . . . . . . . . . . . . . . . . . . . . 47
A sample publication . . . . . . . . . . . . . . . . . . . . . . . 51
5 A Tutorial for Adaptive Server Enterprise Users 53
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
Tutorial: Adaptive Server Enterprise replication . . . . . . . . 57
Start replicating data . . . . . . . . . . . . . . . . . . . . . . . 66
iii