Enable Replication with owner_on Status

User tables may have the same name but different owners. Adaptive Server allows you to mark a table for replication and specify that table owner information should be considered when identifying the table.

To mark the table for replication with the “owner on” status, log in to Adaptive Server and enter: 
sp_setreptable table_name, 'true', owner_on

At the Replication Server, the replication definition for the table must identify the table owner. For example, if you set owner status for a table to “owner on” with sp_setreptable, you must include an owner name when you create the replication definition or Replication Server will be unable to find the correct table at the replicate database.

The owner of the source table and the owner of the destination table can be different.

Note: If you specify “owner off” status for a table, Replication Server does not send table owner information to the replicate site. However, if you are replicating to a standby database, Replication Server sends “dbo” as the table owner.

Refer to your Replication Agent documentation to see if your non-Sybase data server allows user tables with the same name but different owners.

Parent topic: Use the sp_setreptable System Procedure