About this book

The ASE Replicator User’s Guide describes how to use the ASE Replicator feature of Sybase® Adaptive Server® Enterprise to implement basic replication from a primary Adaptive Server to one or more remote Adaptive Servers.


This book is intended for System Administrators and Database Administrators who want to implement simple Adaptive Server replication with ASE Replicator.

How to use this book

This book contains the following chapters:

Chapter 1, “Introduction to ASE Replicator,” provides an introduction to replication system concepts and an overview of the ASE Replicator. This chapter describes the major ASE Replicator components and explains how they work.

Chapter 2, “Setting Up and Starting ASE Replicator,” describes the initial setup and configuration procedure for ASE Replicator. The setup procedures in this chapter must be performed after installing the software, and before replication can begin.

Chapter 3, “Administering ASE Replicator,” describes administrative operations, including managing and monitoring ASE Replicator and the replication system.

Chapter 4, “ASE Replicator Procedures,” describes the ASE Replicator command procedures in detail, including syntax, options, usage, and examples.

Chapter 5, “Troubleshooting ASE Replicator,” describes basic troubleshooting and recovery procedures for ASE Replicator.

Appendix A, “Distribution Database Schema,” describes the schema of the Distribution Database.

Related documents

The Adaptive Server Enterprise documentation set comprises the following documents:

Other sources of information

Use the Sybase Technical Library CD and the Technical Library Product Manuals Web site to learn more about your product:


The following style conventions are used in this manual:

Table 1 shows the conventions for syntax statements that appear in this manual:

Table 1: Syntax statement conventions




Command names, command option names, configuration parameter names, and other keywords are in this font in body text.


Variables, options, or words that stand for values that you fill in, are in this font in body text.

{ }

Curly braces indicate that you choose at least one of the enclosed options. Do not include braces in your option.

[ ]

Brackets mean choosing one or more of the enclosed options is optional. Do not include brackets in your option.

( )

Parentheses are to be typed as part of the command.


The vertical bar means you may select only one of the options shown.


The comma means you may choose as many of the options shown as you like, separating your choices with commas to be typed as part of the command.

In this manual, most of the examples are in lowercase. However, you can disregard case when typing Transact-SQL keywords. For example, SELECT, Select, and select are the same.

Adaptive Server’s sensitivity to the case of database objects, such as table names, depends on the sort order installed on Adaptive Server. You can change case sensitivity for single-byte character sets by reconfiguring the Adaptive Server sort order. See the System Administration Guide for more information.

If you need help

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.