Troubleshooting guide

Note: By default, this DDL creates a table with the owner dbo.

Grant permissions to any new or existing object to be replicated in the primary database:

grant all on ptab1 to public;

Mark the ptab1 table for replication:

sp_setreptable ptab1, 'true'

At the replicate SAP HANA database instance, create a table named PTAB1:

CREATE TABLE PTAB1

(IDNO INT PRIMARY KEY,

NAME VARCHAR(20));

Note: SAP HANA database is not case-sensitive and uses uppercase characters if

lowercase characters are provided.

If an owner is not specified with the tablename, the owner of the table—

—is

the user that is signed on at the time the table is created.

Grant permissions to any new or existing object to be replicated in the replicate database so

that the Replication Server maintenance user can update this table:

grant all privileges on PTAB1 to public

isql –Usa –Psa_pass –SSAMPLE_RS

If you have not set up the sample Replication Server instance, enter your Replication

Server instance name in place of SAMPLE_RS.

Create a replication definition against the primary Adaptive Server database.

To create the ptab1_repdef replication definition for the ptab1 table:

create replication definition ptab1_repdef

with primary at pds.pdb

with primary table named ptab1

with replicate table named <tableowner>.ptab1

(idno integer,

"name" varchar(20))

primary key (idno)

where the replicate table on SAP HANA database—ptab1— is owned by

and

pds

pdb

is the name of the primary connection created earlier.

Create a subscription against the replicate connection.

To create the ptab1_sub subscription for the ptab1_repdef replication definition:

create subscription ptab1_sub

for ptab1_repdef

with replicate at rds.rdb

without materialization

where

rds

rdb

is the name of the replicate SAP HANA database connection created earlier.

CHAPTER 3: ASE-to-SAP HANA Database Replication Setup

Quick Start Guide for SAP HANA Database 19