Migrating to the Real-Time Loading Solution

Migrate from the staging solution to RTL.

1. Create a maintenance user in the replicate Sybase IQ data server, or you can use the existing maintenance user.
2. Create the connection to the replicate Sybase IQ database from the replicate Replication Server using the rs_oracle_to_iq connection profile and the maintenance user from step 1, such as dbmaint:

   create connection to IQSRVR.iqdb
   using profile rs_oracle_to_iq;standard
   set username to dbmaint
   set password to dbmaint
   go

3. At the primary database, if a table owned by dbo is not marked as owner_on, you must enable owner for the table so that Sybase IQ can find the table since dbo does not exist in Sybase IQ:

   pdb_setreptable testtab, mark, owner
   go

4. Re-create the replication definition to include owner information since you have enabled owner.
5. If there are referential constraints between tables, you must alter the replication definition to define referential constraints so that Replication Server is aware of the referential constraints and can perform bulk apply in the proper order.
6. Enable RTL for the connection to the replicate database:

   alter connection to iqserver_name.iqdb
   set dsi_compile_enable to 'on'

   After suspending and resuming the connection, the change in the connection takes effect.

7. Create subscriptions for each table. If the primary and replicate database are synchronized, include the without materialization clause in the subscription. Otherwise, you must enable autocorrection during materialization.