Chapter 12 Working with Replication Server

Transferring Data from the staging database into Sybase IQ

When the replication is set up, you can start RepServer to begin data replication. Data modifications made in the source database are replicated to the Sybase ASE staging database or the staging tables in Sybase IQ. At some point, you need to transfer the data from the staging database into Sybase IQ.

You automate this process using a script that performs the following tasks periodically.

Steps To transfer data from the staging database into Sybase IQ:

  1. Suspend replication to make sure data will not change during the transfer from staging database to Sybase IQ.
  2. Run the IQ_LOAD_STAGING stored procedure in Sybase IQ to move data into Sybase IQ.
  3. Run the IQ_CLEAN_STAGING stored procedure in Sybase ASE staging database to remove the already transferred data.
  4. Resume replication.

 

Copyright (C) 2007. Sybase Inc. All rights reserved.