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 version 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:
All Replication Servers are at version 15.1
You will not need to downgrade any Replication Server to an earlier version
You will not need to install any Replication Servers of an earlier version
sysadmin system_version, 1510
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.
System Version and Site Version
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 version—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 version 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 version 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.
Mixed-Version Replication Systems
If all of your Replication Servers are at version 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 Server 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 version, see the Replication Server New Features Guide for that version.
System Version and the ID Server
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.
System Tables for Version InformationVersion information is stored in the <rs_version> system table. The <rs_routes> system table also contains version information.
sysadmin system_version requires “sa” permission.