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 upgrade process makes changes to the system databases that you cannot roll back if the upgrade fails. Restore the system databases if the upgrade fails.
If you plan to install the Replication Server software in a directory other than an existing Sybase version directory, verify that the sql.ini file is accessible.

Task

Note: If you have upgraded to a Replication Server version available only on 64-bit platforms, you cannot migrate back to a 32- bit platform. See the Replication Server 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
```
Retry with admin quiesce_force_rsi if Replication Server is not yet quiesced.
Warning! You may lose data if you proceed with the downgrade 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/ASA12/
lib:$SYBASE/REP-15_5/lib64:$SYBASE/REP-15_5/
lib:$SYBASE/REP-15_5/lib3p64/log4cxx/lib:$SYBASE/
OCS-15_0/lib:$SYBASE/OCS-15_0/lib3p64:$SYBASE/OCS-15_0/
lib3p

Start the ERSSD:

C:\sybase\REP-15_5\ASA12\win32\dbspawn.exe -f -q 
C:\sybase\REP-15_5\ASA12\win32\dbsrv12.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

See your Replication Server log file for the actual commands to start the ERSSD by searching for “ERSSD start command.”

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.