Before migrating

Before you migrate from the staging solution:

1. To use RTL, you must upgrade both the primary and replicate Replication Servers to version 15.5. See the Replication Server Installation Guide and Replication Server Configuration Guide for installation and upgrade instructions.

2. Verify that no transactions flow into pdb1 and that the replication system is quiesced during migration:

   1. Stop Replication Agent for all primary databases and system databases by executing on Replication Server:

      suspend log transfer from all
      

   2. Stop RepAgent for the RSSD if you are using Adaptive Server as the RSSD:

      sp_stop_rep_agent emb
      

   3. Verify that the Replication Server queues have been drained out and Replication Server has been quiesced by executing:

      admin quiesce_check
      

      Retry with admin quiesce_force_rsi if Replication Server is not quiesced yet. If Replication Server is not quiesced, data loss is possible.

3. Verify that pdb1 and iqdb are synchronized. You can resynchronize the databases by loading data to iqdb from the staging database after all the data is replicated to the staging database. If you do not a resynchronize the databases, you must purge and materialize iqdb.

4. Add an entry for the replicate Replication Server (RRS) to the Sybase IQ interface file to allow the Sybase IQ server to connect to the replicate Replication Server and pull data.