Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Chapter 3:  Setting Up SQL Remote [Table of Contents] Chapter 5:  A Tutorial for Adaptive Server Enterprise Users

Data Replication with SQL Remote

[-] Part 1 Introduction to SQL Remote
[-] Chapter 4: A Tutorial for Adaptive Server Anywhere Users

Chapter 4

A Tutorial for Adaptive Server Anywhere Users

About this chapter

This chapter guides you through setting up a simple replication system.

[-] Tutorial overview
Tutorial goals
The database
Replication goals
Sybase Central or command-line utilities
[-] A tutorial using Sybase Central
Preparing for the Sybase Central replication tutorial
[-] Setting up a consolidated database
Add a SQL Remote message type
Add the publisher and remote user to the database
Add publications and subscriptions
Set up the remote database in Sybase Central
[-] A tutorial using Interactive SQL and DBXTRACT
Preparing for the replication tutorial
[-] Set up the consolidated database
Create a SQL Remote message type
Grant PUBLISH and REMOTE at the consolidated database
Create publications and subscriptions
[-] Set up the remote database
Extract the remote database information
Load the remote database information
[-] Start replicating data
Enter data at the consolidated database
Send data from the consolidated database
Receive data at the remote database
Replicate from the remote database to the consolidated database
A sample publication


Chapter 3:  Setting Up SQL Remote [Table of Contents] Tutorial overview