Marking Tables to Prepare for Replication Testing

Mark tables in the primary database that you want to replicate to the Sybase IQ database

In these examples, dbo is the table owner of testtab in the pdb1 primary database. c1, c2, and c3 are columns in testtab with int, int, and char(10) datatypes, respectively.

  1. Insert data rows into testtab for testing replication and verify the inserts are successful.
    For example, in Adaptive Server:
    insert into testtab values(1,1,‘testrow 1’)
    insert into testtab values(2,2,‘testrow 2’)
    insert into testtab values(3,3,‘testrow 3’)
    go

    If the inserts are successful, you see:

    (1 row affected)
    (1 row affected)
    (1 row affected)
  2. Mark testtab for replication.
    • Adaptive Server – use the sp_setrepdefmode system procedure.
      • Adaptive Server 15.0.3 and later:
        sp_setrepdefmode testtab,'owner_on'
        go
      • Versions earlier than Adaptive Server 15.0.3:
        sp_setreptable testtab,'true', 'owner_on'
        go
    • Oracle – use the pdb_setreptable Replication Agent command:
      pdb_setreptable pdb_table, mark, owner
      See Replication Server Options > Replication Agent Administration Guide > Setup and Configuration > Primary Database Object Marking > Marking a Table in the Primary Database for more usage information.