Transferring Staged Data to 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.

  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.
Parent topic: Modeling Replications to a Sybase IQ Data Warehouse