Sybase Enterprise Data Studio Feature Guide

Home

Sybase Enterprise Data Studio Feature Guide

Chapter 1: Enterprise Data Studio:An Overview

Five Options

Adaptive Server Enterprise Replication

The Adaptive Server Enterprise Replication option provides Adaptive Server and all the database services of the Adaptive Server Enterprise option plus the ability to replicate data over the network to other Adaptive Server databases using Sybase Replication Server.

Replication Server maintains replicated data in multiple databases while ensuring the data's integrity and consistency. It provides users with local data access, thereby reducing load on the network and centralized computer systems.

With the Adaptive Server Enterprise Replication option, you can:

Use all the features provided with the Adaptive Server Enterprise option.
Replicate data from Adaptive Server databases to other Adaptive Server databases anywhere on the client/server network.
Maintain a warm standby copy of a primary database so that, if the primary system fails, clients can switch to the standby copy almost immediately.
Replicate an online transaction processing (OLTP) database to a decision-support database, to run decision-support queries in near real time, without affecting OLTP performance.
Synchronize databases with different schemas, formats, and naming conventions.
Replicate the execution of stored procedures from one database to another.
Continue to work even if some system components are unavailable. Replication Server saves transactions in stable queues that allow databases to resynchronize without losing information.
Manage your Replication Servers and your replication system using the Sybase Central graphical interface.

Table 1-3 lists the server and PC-client components that you can install from the Adaptive Server Enterprise Replication option. See Appendix A for a description of each component.

Table 1-3: Adaptive Server Enterprise Replication components
Adaptive Server Enterprise Replication
Server Components
Adaptive Server Enterprise
Replication Server
Replication Agent for Adaptive Server Anywhere
ESQL/C and ESQL/COBOL
Full-Text Search Specialty Data Store
jConnect for JDBC
Language Modules Adaptive Server, DirectConnect, and Replication Server
Adaptive Server Enterprise Monitor Server,
Monitor Client Library, and Monitor Historical Server
Open Client
Open Server
PowerDynamo
Security Guardian
Specialty Data Store Developer's Kit
SQL Remote (for Adaptive Server)
Sybase Character Sets
XA-Library for CICS and Encina
XA-Server for TUXEDO
PC-Client Components
InfoMaker
jConnect for JDBC
Language Modules
Monitor Client Library for Windows NT
ODBC Driver for Adaptive Server Enterprise
Open Client and Open Client Runtime for
Windows 95 and Windows NT
Open Server
PowerDynamo
SQL Advantage
SQL Modeler
SQL Remote
Sybase Central viewer
Sybase Central plug-ins for Adaptive Server, PowerDynamo, and Replication Server
Sybase Character Sets


	Expand Search