In a Sybase transaction replication system, both the Mirror Replication Agent and Replication Server components provide features that allow you to select the objects that you want to replicate. You do not need to replicate all objects or all data-changing operations in the primary database.
If a primary database object (such as a table or stored procedure) is not replicating, verify the object that you intended to replicate is marked.
To verify that a primary database object is marked
for replication
Log in to the Mirror Replication Agent instance with the administrator login.
Use the appropriate command to determine if the object is already marked:
For a table:
pdb_setreptable pdb_table
where pdb_table is the name of the table that you want to verify is marked for replication.
For a LOB column:
pdb_setrepcol pdb_table, pdb_col
where:
pdb_table is the name of the marked table that contains the LOB column.
pdb_col is the name of the LOB column.
For a stored procedure:
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure in the primary database that you want to verify is marked for replication.
For DDL:
pdb_setrepddl pbd_ddl
where pdb_ddl is the name of the DDL in the primary database.
It returns the current DDL replication status for the primary database. Verify that DDL replication status is enabled to replication DDL commands.
After you verify that the primary database objects are marked, see the following table:
If... |
Then... |
|---|---|
The primary database object is not marked. |
Mark the object:
|
The primary database object is marked. |
