Upgrade the RSSDs or ERSSDs so they are compatible with the new
executable programs. Upgrading an RSSD or ERSSD may add
new Replication Server system tables, add new rows or columns to existing
tables, or install new stored procedures.
Upgrade an RSSD based on the information from the Replication Server installation worksheet for the Replication Server you are upgrading.
-
Verify that the RSSD and Replication Servers that you are upgrading are
running.
-
If the Replication Server uses Adaptive Server for the RSSD, grant sa_role
to the primary user at the RSSD:
sp_role 'grant', sa_role, primary_user
You can revoke the “sa” role after the upgrade process is finished, by executing:
sp_role 'grant', sa_role, primary_user
Note: The RSSD_primary_user in the .cfg file must have a replication role
or “sa” role. The RSSD_primary_user may not necessarily be the sa user ID or the user that has been entered in the
rs_init pane.
-
If the Replication Server uses an ERSSD, edit the
rs_name.cfg file, where
rs_name is your Replication Server:
-
Add the erssd_release_dir parameter to specify the location of the SQL Anywhere ERSSD database that you are going to upgrade. For example:
erssd_release_dir=c:\sybase\REP-15_5\ASA11
-
Add the erssd_start_cmd parameter to specify the command to start
the previous version of ERSSD.
You can find an example of the parameter in the Replication Server
log file by searching for “ERSSD start command”. At the entry for "ERSSD start command", you see for example:
ERSSD start command:=c:\sybase\REP-15_5\ASA11\bin\dbspawn
-f -q c:\sybase\REP-15_5\ASA11\bin\dbsrv11
-s none -ti 0 -x "tcpip(PORT=15501;DOBROAD=NO;BLISTENER=NO)"
-o c:\sybase\REP-15_5\errorlog\rs155_prs_ERSSD.out
c:\sybase\REP-15_5\dbfile\rs155_prs_ERSSD.db
-
From the sql.ini file, obtain the name and location of the Replication Server you are
upgrading, and the port number of the Replication Server RSSD.
-
If the Replication Server uses an ERSSD, and is performing routing, edit the
rs_name.cfg file, where rs_name is your Replication Server:
-
Add the erssd_ra_release_dir parameter to specify the location of the
SQL Anywhere ERSSD database that you are going to upgrade. For example:
erssd_ra_release_dir=c:\sybase\REP-15_5\ASA11
-
Add the erssd_ra_start_cmd parameter to specify the command to start
the previous version of ERSSD.
Obtain the name of the ERSSD Replication Agent and the location of
the sql.ini file from the Replication Server log file by searching for
“Starting embedded RSSD Replication Agent” and using the same
command format from the next line: “Executing command:”. For
example:
erssd_ra_start_cmd=c:\sybase\REP-15_5\ASA11\bin\dbltm
-ud -S SAMP_RS_ERSSD_ra
-C c:\sybase\REP-15_5\samp_repserver\SAMP_RS_ERSSD_ra.cfg
-ot c:\sybase\REP-15_5\samp_repserver\SAMP_RS_ERSSD_ra.out
-I c:\sybase\sql.ini
-
Select
You see the RS_INIT dialog box.
-
Select Configure a Server Product. Choose Continue.
-
Select Replication Server.
Then choose Continue.
-
Select Upgrade an Existing Replication Server.
Then choose Continue.
-
Complete the Upgrade Existing Replication Server window with the
information from the “Replication Server installation worksheet” for the Replication Server you are upgrading.
-
Enter the name of the Replication Server with the RSSD you are
upgrading.
-
Enter the login name for the Replication Server “sa” user. The default
value is “sa.”
-
Enter the password for the “sa” user on the Replication Server.
-
Enter the path name of the Replication Server configuration file.
-
Choose Continue to save your changes. You see:
Execute the Replication Server tasks now?
-
Choose Continue. If the Replication Server is running, rs_init shuts it down.
rs_init displays informational messages as it loads the upgrade script into
the RSSD. When the upgrade is complete, you see:
RSSD successfully upgraded from old_rel_no to
new_rel_no. Replication Server 'rs_name' can now be
restarted. Task to upgrade the RSSD succeeded.
Configuration completed successfully.
where:
-
old_rel_no – is the Replication Server version from which you are
upgrading.
-
new_rel_no – is the new Replication Server version.
-
rs_name – is the name of the Replication Server.
-
If you have more Replication Servers to upgrade, repeat the upgrade procedures.
-
If you installed the new Replication Server software in a different
directory than the earlier version, modify the runserver files for the
Replication Servers so that they use the programs in the new version
directory.
-
Restart Replication Server using the appropriate executables for the new
version.
Warning! Some Replication Server configuration options with newer versions
may have a wider valid range. If you increase any of these configuration
options after upgrading, you must reinstate the old values before downgrading.
Otherwise, the Replication Server may not start or may behave incorrectly. The
Replication Server upgrade process prints all the current configuration option
values in rs_config to rs_init log, so that you can restore the former settings
before downgrading.