Testing Replication

When you finish setting up the replication system, test that replication works as intended.

Connect to the primary Microsoft SQL Server database as a regular user, rather than as the maintenance user. Make sure the regular user also exists in the replicate database.
At the primary Microsoft SQL Server database, create a table named ptab1 to replicate:
```
CREATE TABLE ptab1
(idno int PRIMARY KEY,
name varchar(20));
```
Grant permissions to any new or existing object to be replicated in the primary database:
```
grant all on ptab1 to public;
```
Connect to Replication Agent through isql, and mark the ptab1 table for replication:
```
pdb_setreptable ptab1, mark
go
```
In Replication Agent, create a replication definition against the primary Microsoft SQL Server database:
```
1> rs_create_repdef ptab1
2> go
Table/Procedure Name    RepDef Name    Status
----------------------- -------------- --------
<MSSQLTableOwner>.PTAB1 "<repdefname>" Created
(1 row affected)
```
Record the name of the replication definition for use later.
At the replicate SAP HANA database instance, create a table named PTAB1:
```
CREATE TABLE <tableowner>.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—<tableowner>—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 <tableowner>.PTAB1 to public
```
Log in to Replication Server:
```
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.
Alter the replication definition that you created earlier to point to the correct replicate table:
```
alter replication definition <repdefname>
with replicate table named <tableowner>.ptab1
go
```
Create a subscription against the replicate connection.
To create the ptab1_sub subscription for the <repdefname> replication definition:
```
create subscription ptab1_sub 
for <repdefname>
with replicate at rds.rdb
without materialization
go
```
where <repdefname> is the replication definition that you altered in the previous step, and rds.rdb is the name of the replicate SAP HANA database connection created earlier.
For information on using the create subscription command in direct load materialization, see Replication Server Reference Manual.
On the Microsoft SQL Server database, insert data into the primary ptab1 table and commit:
```
insert into ptab1
values (5, "Joel Robinson")
go
commit
go
```
On the SAP HANA database, verify that the data replicated to the replicate PTAB1 table:
```
SELECT * FROM <tableowner>.PTAB1;
```