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 15.0, but you are not migrating from one version of SQL Server to another, use the migration procedure described in the section called “Migrating from version 12.5 to 15.0 for non-Oracle instances”.

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

  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 15.0 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 15.0 software with your replication system.