![]() | ![]() |
Home |
|
|
Data Replication with SQL Remote |
|
| Part 1 Introduction to SQL Remote |
|
| Chapter 4: A Tutorial for Adaptive Server Anywhere Users |
Chapter 4
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 |
|
|