Creating Test Tables

Create a test table in the primary and replicate databases, and grant maintenance user permissions to it to test that replication works.

1. In the primary database pdb1 in the data server, create a table named testtab with three columns: c1 integer, c2 integer and c3 char(10).
   For example, in Adaptive Server:

   use pdb1
   go
   create table dbo.testtab(c1 int primary key, c2 int,
   c3 char(10))
   go

   See Oracle documentation to create a table in the Oracle database.

2. In the replicate database iqdb in the Sybase IQ IQSRVR data server, enter:

   use iqdb
   go
   create table dbo.testtab(c1 int primary key, c2 int,
   c3 char(10))
   go
   grant all on dbo.testtab to public
   go