Manage Replicated Tables

Learn the preparations, the procedures, and the specific commands used to set up manage replicate tables, table replication definitions, and publications.

• Introduction to Managing Replicated Tables
  Replication Server allows you to copy and update data from a table in one database—the primary—to a table in another database—the replicate.
• Plan a Replication System
  Planning a replication system includes considering the design, being aware of the restrictions on data replication, and preparing the replication system.
• Summary of Procedures for Replicating Tables
  The replication procedure consists of several steps required to replicate data between tables using table replication definitions and subscriptions.
• Create Replication Definitions
  A replication definition describes the primary table to Replication Server, specifying the columns you want to copy.
• Mark Tables for Replication
  After you create a replication definition for the table, use sp_setreptable to mark the table for replication.
• Replicate Java Columns
  You can replicate Java columns stored in your primary database to your standby and replicate databases.
• Replicate text, unitext, image, and rawobject Columns
  Replication Server lets you replicate columns that use the Adaptive Server datatypes text, unitext, image and rawobject.
• Replicate Large-object (LOB) Datatypes
  Replication Server supports the replication of Microsoft SQL Server 2005 datatypes varchar(max), nvarchar(max), and varbinary(max). These datatypes can each store up to 2,147,483,647 bytes of data..
• Replicate Computed Columns
  Computed columns allow you to create an expression and place the result of the expression in a table column.
• Replicate Encrypted Columns
  With version 15.0, Replication Server supports replication of encrypted columns in Adaptive Server.
• Replicate Encrypted Data
  Replication Server supports the replication of encrypted data.
• Work with Special Datatypes
  Learn how to use the rs_address, identity, and timestamp special datatype columns in replication definitions.
• Modify Replication Definitions
  Learn how to view, alter, and drop replication definitions and learn how Replication Server supports table changes.
• Modify Replicated Data
  Learn how to modify replicated data and perform related operations to maintain replication.
• Use Publications
  A publication lets you collect replication definitions for the same or related tables and stored procedures and then subscribe to them as a group.
• Translate Datatypes Using HDS
  In a heterogeneous replication system, when information is replicated from one data server to another, values stored at the primary data server must often be altered so that they can be copied successfully to a different datatype at the replicate data server.