Sybase SQL Remote DC38133-01-0902-01 Manuel D’Utilisation
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