SAP Knowledge Base Article - Preview

2546074 - SQL statement replication doesn't work - SRS

Symptom

  1. Setting up MSA replication with SQL statement replication.
  2. It is not taking statement replication and replicating normal replication; 
  3. Replication definition:
    create database replication definition "repdefname"
    with primary at PDS.pdbname
    replicate ddl replicate functions
    not replicate system procedures in ( 'sp_adduser','sp_dropuser' )
    replicate sqldml
  4. in primary database, run
    sp_setrepdbmode dbname, 'UDIS', 'on'
    go
    sp_setrepdbmode dbname, threshold, "1"
    go

Read more...

Environment

SAP Adaptive Server Enterprise 15.7 SP138 or higher

SAP Replication Server (SRS) 15.7.1 or higher

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

SQL statement replication, repdef, SQLDML , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.