Migrating Between 32-Bit and 64-Bit Platforms

Replication Server is available on 32-bit and 64-bit platforms for Windows.

Prerequisites

Back up your replication system. The migration process makes changes to the system databases that you cannot roll back if the migration fails. Restore the system databases if the migration fails.
If you plan to install the software in a directory other than an existing version directory, verify that the sql.ini file is accessible.

Task

Note: This migration procedure applies only for migration in the same RSSD version and platform. If you have migrated to a Replication Server version that is available only on 64-bit platforms, you cannot migrate back to a 32-bit platform. See the release bulletin for supported 64-bit platforms.

Stop Replication Agent for all primary databases and system databases by executing this command on Replication Server:
```
suspend log transfer from all
```
If you are using Adaptive Server as your RSSD, stop RepAgent for the RSSD:
```
sp_stop_rep_agent RSSD_name
```
If you are going to migrate a Replication Server, log in to each upstream Replication Server and suspend all the routes to the Replication Server you are migrating:
```
suspend route to replicate_Replication_Server
```
Verify that the Replication Server queues have been drained and that Replication Server has been quiesced:
```
admin quiesce_check
```
If Replication Server has not yet quiesced, use admin quiesce_force_rsi .
Warning! You may lose data if you proceed with the migration process without quiescing Replication Server.
Stop Replication Server.
1. Log in to the Replication Server as the system administrator:
```
isql -Usa -Psa_password -Sservername
```
2. Enter:
```
1> shutdown
2> go
```

If you are using an ERSSD, manually restart it:

Set the LD_LIBRARY_PATH environment variable:

$ export
LD_LIBRARY_PATH=$SYBASE/REP-15_5/ASA16/
lib:$SYBASE/REP-15_5/lib64:$SYBASE/REP-15_5/
lib:$SYBASE/REP-15_5/lib3p64/log4cxx/lib:$SYBASE/
OCS-16_0/lib:$SYBASE/OCS-16_0/lib3p64:$SYBASE/OCS-16_0/
lib3p

Start the ERSSD:

C:\sybase\REP-15_5\ASA16\win32\dbspawn.exe -f -q 
C:\sybase\REP-15_5\ASA16\win32\dbsrv16.exe -ti 0 -x
"tcpip(PORT=11751;DOBROAD=NO;BLISTENER=NO)" -o
C:\sybase\REP-15_5\errorlog\SAMPLE_RS_ERSSD.out
C:\sybase\REP-15_5\dbfile\SAMPLE_RS_ERSSD.db

In your Replication Server log file, search for “ERSSD start command”, to see the actual commands for starting the ERSSD.

Load the migration script file into the ERSSD or RSSD. For example:
- ERSSD – load %SYBASE%\REP-15_5\scripts\rs_migration_asa.sql into the ERSSD.
- RSSD – load %SYBASE%\REP-15_5\scripts\rs_migration_ase.sql into the RSSD.
Start Replication Server from the new Replication Server executable.