Downgrading from Replication Agent for Oracle 12.6  Glossary

Appendix A: Migration in Replication Agent

Migrating from SQL Server 7.0 to SQL Server 2000

Use the following migration procedure if you are using Sybase Replication Agent and you migrate the primary database from Microsoft SQL Server 7.0 to SQL Server 2000 (8.0).

NoteIf you are migrating from Sybase Replication Agent version 12.5 to 12.6, but you are not migrating from one version of SQL Server to another, use the migration procedure described in “Migrating from version 12.5 to 12.6 for non-Oracle instances”.

StepsTo migrate from SQL Server 7.0 to SQL Server 2000 with Replication Agent 12.6

  1. Quiesce the replication system and stop all transaction activity on the primary database.

  2. Unmark all primary objects (tables and stored procedures) in the primary database.

  3. Remove all Replication Agent transaction log objects from the primary database:

    pdb_xlog remove
    
  4. Uninstall the earlier version of the Sybase Replication Agent software using the uninstall utility provided with the software.

  5. Install the Sybase Replication Agent 12.6 software using the instructions in “Installing the Sybase Replication Agent software” in the Sybase Replication Agent Installation Guide.

  6. Follow the procedures in Chapter 2 and Chapter 3 of the Sybase Replication Agent Administration Guide to set up the Replication Agent 12.6 software with your replication system.





Copyright © 2005. Sybase Inc. All rights reserved. Glossary

View this book as PDF