Preparing to Migrate from the Staging Solution

Before you migrate from the staging solution, you need to perform some tasks.

1. You must upgrade both the primary and replicate Replication Servers to version 15.5 or later.
   See the Replication Server Installation Guide and Replication Server Configuration Guide.
2. Verify that no transactions flow into pdb 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 rssd_name

   3. Verify that the Replication Server queues have drained and that 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, you may lose data.
3. Verify that pdb 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 resynchronize the databases, you must purge and materialize iqdb.
4. Add an entry for the replicate Replication Server to the Sybase IQ interfaces file to allow the Sybase IQ server to connect to the replicate Replication Server and pull data.