Planning the SQL Replication tutorial

This tutorial is based on assumptions about what you want to replicate and which options you will choose.

Assume that your group uses an application that generates reports. This application needs information that exists in the DEPARTMENT table of the SAMPLE database. Instead of copying the data directly from the source table, you want the application to copy its changes to a target table that only the report-generating application can read. For ease of administration, you decide to keep the target table on the same machine as the source table.

You require a simple data distribution configuration, involving the replication of changes from one replication source to a single read-only copy. The next topics describe the design and planning issues that you need to consider before you perform any replication tasks.

  1. Replication options
    You can choose replication options that, for example, determine where the change-data (CD) table, target table, and control tables are stored, how often you want replication to occur, and which records (based on the criteria you specify) you want to delete from the IBMSNAP_APPLYTRAIL table after each replication cycle.
  2. Replication source
    The replication source is the table in a database from which you want to extract data to replicate to a table in your replication target. Before you set up your environment, you must decide what you want to replicate from that table.
  3. Replication target
    The replication target is the table in a database to which you want to replicate data from your replication source. You can create a new table in your target database or use an existing target table. For this tutorial, you will create a new table.
Previous topic: Before you begin
Next topic: Setting up the replication environment for this tutorial