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.

A row comparison sorts rows by a primary or a unique key, from all participating database tables and compares them one by one. A comparison summary is stored in the Data Assurance System Database (DASD). Detailed text or XML reports showing the row differences are stored in the data directory.

Schema comparison lets you compare the schema of one primary database against one or more replicate databases. You can compare an entire database schema using automatic table name mapping, or you can compare specific tables using table name mapping.

Related tasks
Creating a Job
Creating a Schema Job
Related reference
create job
create schema job