Creating test tables

To test that replication works in these examples, create the testtab table in the primary and replicate databases and grant permissions to testtab logged in as the maintenance user.

1. At the primary database pdb1 in Adaptive Server, create the table

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

2. At the replicate database iqdb in the IQSRVR Sybase IQ data server:

   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