Displays or sets the system-wide version number for the replication system, allowing you to use the software features in the corresponding release level.
Starting with release 11.5, the site version for individual Replication Servers also enables new features. The system version number need not correspond to the current software version.
sysadmin system_version [, version]
The system version number to use for the replication system.
Executed at the ID Server, displays the current system version number:
sysadmin system_version
Executed at the ID Server, changes the system version number to correspond to release 15.1. You can use this number if:
All Replication Servers are at release 15.1
You will not need to downgrade any Replication Server to an earlier release
You will not need to install any Replication Servers of an earlier release
sysadmin system_version, 1510
To set the system version number, execute sysadmin system_version at the ID Server, and include a version parameter.
The system version number you enter must be no higher than the lowest software version number—the release level of a Replication Server—of any Replication Server in the replication system.
You cannot set the system version number at any other Replication Server than the ID Server.
To display the current system version number, execute sysadmin system_version at the ID Server, without a version parameter.
If you execute this command at another Replication Server, the Replication Server tries to contact the ID Server to determine the current system version number. In rare cases, a Replication Server may be unable to contact the ID Server. For this reason, only the value at the ID Server is guaranteed to be correct.
Starting with Replication Server release 11.5, you can use certain new software features when the Replication Server’s site version number has been set to the current software release—for example, 1510 for release 15.1. See sysadmin site_version for more information.
A minimum system version number of 1102 is also required.
When you install a Replication Server of release 11.5 or higher as the ID Server for a new replication system, the system version number is set to 1102. This number allows you to install additional Replication Servers of release 11.0.2 or later into the system.
For more information about installing or upgrading Replication Servers, refer to the Replication Server installation and configuration guides for your platform.
If all of your Replication Servers are at release 11.0.2 or later, the highest required setting for the system version number is 1102. After setting the system version number to 1102, you may never need to set it again.
A 1102 system version number and site version number for individual Replication Servers allows a mixed-version replication system, in which Replication Servers of different site versions can work together. Each Replication Server can use its full set of available features.
In a mixed-version replication 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 1510, while the site version of its other replicate Replication Server 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 1510 site version can subscribe to the timestamp column directly. See sysadmin site_version for more information.
For more information about features that were introduced in a particular Replication Server software release, see the Replication Server New Features Guide for that release.
In Replication Servers other than the ID Server, when a command is executed that requires a certain minimum system version, the Replication Server contacts the ID Server to determine the current system version number before allowing use of the command.
Version information is stored in the rs_version system table. The rs_routes system table also contains version information.
sysadmin system_version requires “sa” permission.
