Replication Server Data Assurance Option

Replication Server Data Assurance Option compares row data and schema between two or more Adaptive Server® Enterprise databases, and reports discrepancies.

Replication Server Data Assurance Option is a scalable, high-volume, and configurable data comparison product. It allows you to run comparison jobs even during replication by using a “wait and retry” strategy that eliminates any down time.

Each comparison job lets you check for data discrepancies using a number of settings that determine which data is being compared and in what way. Replication Server Data Assurance Option includes a command line tool (CLT) that allows users to perform all comparison and reporting jobs. Users can monitor and abort jobs, as well as generate detailed comparison reports. Replication Server Data Assurance Option is licensed through SySAM license manager and is available on multiple platforms.

For more information about SySAM, see the installation guide for your platform, or the SySAM Web site: http://www.sybase.com/sysam.

• System Architecture
  A Replication Server Data Assurance Option system has a central Data Assurance (DA) server component with zero or more satellite DA agents. The exact number of servers and agents depends on your deployment type: single-server or distributed.
• Data Assurance Agents
  Data Assurance (DA) agents fetch and compress data from databases into the DA server.
• Connection Profiles
  A connection profile contains the information required to establish a database connection.
• Comparesets
  Comparesets, which consist of sets of tables and columns, define the data being compared in a particular job.
• Jobs and Comparisons
  A job is a collection of one or more row or schema comparison tasks. You can create jobs manually, or automatically, based on the information in a Replication Server System Database (RSSD). You can run jobs manually, or schedule them to run at a specific time or interval.
• Data Assurance System Database
  The Data Assurance System Database (DASD) stores all comparison information.
• Integration with Replication Server
  Replication Server Data Assurance Option integrates with Replication Server to automatically import DA server jobs that are based on the information in the Replication Server System Database (RSSD). The DA server directly connects to the RSSD and retrieves the information about table replication definitions and subscriptions to determine the tables and columns that are defined for replication between the primary and replicate databases.