Test replication

This section describes the steps required to test replication.

Connect to the primary ASE database as a user.

WARNING! Sybase recommends that you do not use the maint user because maint user filtering is enabled by default and transactions by this user will not be replicated.
Create a test table to replicate (unless it already exists):
```
create table T1( a int, b char(10))
```
After the elapsed time referenced by the Mirror Replication Agent setting in scan_sleep_max, the test table named “T1” should be replicated to the target ASE instance.
Grant permissions to any new or existing object to be replicated, so that the Replication Server maintenance user can update this table:
```
grant all on T1 to public
```
After the table is marked and the Mirror Replication Agent is in a REPLICATING state, insert test data into the test table and commit it:
```
insert into T1 values ( 42, ‘foo’ ) go
```
Using your preferred ASE query tool, examine the standby site for results and compare the contents of your test table from both the primary and standby sites.

What to do if replication fails

If replication fails, refer to the Mirror Replication Agent Administration Guide, in Chapter 2, “Troubleshooting Mirror Replication Agent,” the section titled, “Examining the Mirror Replication Agent when replication failure occurs.”