Scenario for replication to Sybase IQ

The following sections describe a scenario to set up replication to Sybase IQ using RTL and to test that replication works.

The Adaptive Server database administrator (ASE DBA), the Sybase IQ database administrator (IQ DBA), and you, as the replication system administrator (RSA), must prepare Adaptive Server, Replication Server, and Sybase IQ for replication and set up the connection to the Sybase IQ database:

In this scenario, dbo is the table owner of the testtab table in the pdb1 database of the ASE_DS primary Adaptive Server. c1, c2, and c3 are columns in testtab with int, int, and char(10) datatypes respectively, and IQSRVR is the replicate Sybase IQ data server containing the iqdb database.