Specify Data for Replication

Replication Server lets you define the data and stored procedures that you want to replicate at remote databases, as well as letting you specify the destination databases themselves.

Replication Server uses the relational database model to represent data in tables that have a fixed number of columns and a varying number of rows. Each table you want to replicate must have one or more columns that can be used as a primary key to uniquely identify each row.

As part of design and planning, you designate source and destination databases for your replication system and create the routes that replicated data follows from one Replication Server to another.

In general, a source database contains primary data and may be called the primary database, while a destination database contains replicate data and may be called the replicate database. Depending on your implementation, the same database may contain both primary and replicate data. Transactions or stored procedure executions are replicated from primary to replicate databases. Stored procedure executions may also be replicated from replicate to primary databases.

• Replication Definitions and Subscriptions for Tables
  You create one or more replication definitions to describe each primary (source) table.
• Replication Definitions for Database Objects
  You can use multisite availability (MSA) to create a single database replication definition to describe the data to be sent to the replicate database.
• Replication Definitions for Stored Procedures
  A replication definition of a stored procedure is called a function replication definition.
• Publications
  A publication lets you collect replication definitions for related tables and stored procedures and then subscribe to them as a group.
• Overview of Replicating Tables
  Learn the tasks you must perform at the data servers and Replication Servers in a replication system to replicate transaction data from a primary (source) to a replicate (destination) table.
• Commands for Managing Replicated Data
  Replication Manager plug-in help lists tasks and concepts for working with table replication definitions, function replication definitions, and subscriptions in Sybase Central. Replication Server also provides table replication definition, function replication definition, publication, subscription, and publication subscription RCL commands to manage replicate data.