sysadmin site

Sets the site version number for the Replication Server. This lets you use the software features in the corresponding version, and prevents you from downgrading to an earlier version. If the Replication Server uses ERSSD, this command also shuts down the ERSSD, upgrades its database file and restarts ERSSD.

Note: If your Replication Server uses ERSSD, this command may cause some threads to shutdown since ERSSD is being restarted. Replication should continue after you restart all threads that are shutdown.

Syntax

sysadmin site_version [, version]

Parameters

version – The site version number for Replication Server.
Version Number

Site Version

Pre-11.5

N/A

11.5

1150

12.0

1200

12.5

1250

12.6

1260

15.0, 15.0.1

1500

15.1

1510

15.2

1520

15.5

1550

No site version numbers exist for versions earlier than 11.5. Maintenance releases may support higher site version numbers.

Version Number	Site Version
Pre-11.5	N/A
11.5	1150
12.0	1200
12.5	1250
12.6	1260
15.0, 15.0.1	1500
15.1	1510
15.2	1520
15.5	1550

Examples

Example 1 – Displays the current site version number for the Replication Server:
```
sysadmin site_version
```
Example 2 – Changes the site version number to correspond to version 15.5:
```
sysadmin site_version, 1550
```

Usage

To set the site version number for the current Replication Server, execute sysadmin site_version with a version parameter.

The site version number you enter must be no higher than the software version number or the version level of Replication Server.
To display the site version number for Replication Server, execute sysadmin site_version without a version parameter.
You can use new software features up to the version set in Replication Server site version.
For a newly installed Replication Server of version 15.5, the site version number is 1550.
For more information about features that were introduced in a particular Replication Server software version, see Replication Server New Features Guide for that version.

Warning! When you set the site version number, you cannot downgrade to an earlier version.
For more information about installing or upgrading Replication Servers, see the Replication Server installation and configuration guides for your platform.

Mixed-Version Replication Systems

In a mixed-version replication system, different Replication Servers have different site versions. In such a system, some features are only available to Replication Servers with higher site versions. For example, the site version of a primary Replication Server and one of its replicate Replication Server is 1550, while the site version its other replicate Replication Servers is 1260. When a table replication definition has a timestamp column, the replicate Replication Server with the lower site version can only subscribe to the timestamp as varbinary (8), while the replicate Replication Server with 1550 site version can subscribe to the timestamp column directly.

Upgrading Routes

After you have upgraded one or both Replication Servers on either end of a route to a higher version level, and you have set the site versions to a higher level, you need to upgrade the route. Upgrading a route rematerializes the data in system tables and makes information associated with new features available to a newly upgraded Replication Server.
There are two possible scenarios for route upgrade:
- If you have Replication Manager, use the Replication Manager to upgrade routes. For instruction on upgrading routes, see the Replication Manager online help
- If new features have not been used at the source Replication Server, use sysadmin fast_route_upgrade to upgrade routes.
For example, if you upgrade a Replication Server of version 12.6 to version 15.0 and set its site version accordingly, you will need to upgrade a route from another Replication Server of version 15.0. When you upgrade the route, the newly upgraded Replication Server receives information from the 15.0 Replication Server such as additional replication definitions for the table.

See the Replication Server Configuration Guide for more information about upgrading routes.

System Tables for Version Information

Version information is stored in the rs_version system table. The rs_routes system table also contains version information. Route version information is stored in the rs_routeversions system table.

Permissions

sysadmin site_version requires “sa” permission.