Upgrading Replication Agent for Microsoft SQL Server to 15.7.1 SP100

Upgrade Replication Agent for Microsoft SQL Server to version 15.7.1 SP100.

Note: Replication Agent 15.7.1 SP100 must be installed on the same host on which the primary Microsoft SQL Server is running.

Open a command window.
Set the SYBASE environment variables by changing to the SYBASE directory in which Replication Agent 15.7.1 is installed and executing the SYBASE.bat script.
Change to:
```
cd %SYBASE%\RAX-15_5\bin
```
Note: The Replication Agent directory name for release 15.5 and later is RAX-15_5.

Upgrade the Replication Agent instances.

Option	Description
Upgrading instances within the same product installation	To upgrade a specific Replication Agent instance in the Replication Agent installation directory, at the command prompt, run: ra_admin.bat -u instance=`<instance_name>` To upgrade all Replication Agent instances in the Replication Agent installation directory, at the command prompt, run: ra_admin.bat -u all
Upgrading instances in a separate product installation	To upgrade a specific Replication Agent instance in the specified source instance directory from the current product installation directory, run: ra_admin.bat -u `<source_instance_directory>` To upgrade all Replication Agent instances in the specified source installation directory from the current product installation directory, at the command prompt, run: ra_admin.bat -u `<source_installation_directory>`

Option

Description

Upgrading instances within the same product installation

To upgrade a specific Replication Agent instance in the Replication Agent installation directory, at the command prompt, run:
```
ra_admin.bat -u instance=<instance_name> 
```
To upgrade all Replication Agent instances in the Replication Agent installation directory, at the command prompt, run:
```
ra_admin.bat -u all
```

Upgrading instances in a separate product installation

To upgrade a specific Replication Agent instance in the specified source instance directory from the current product installation directory, run:
```
ra_admin.bat -u <source_instance_directory> 
```
To upgrade all Replication Agent instances in the specified source installation directory from the current product installation directory, at the command prompt, run:
```
ra_admin.bat -u <source_installation_directory>
```

The configuration files are backed up before the upgrade for use in error recovery, if required. If an error occurs, the upgrade is rolled back. The all option requires relatively less space because upgrades are performed directly on instances within the current product installation directory, not to copies. However, reversing an upgrade is more difficult for the same reason.

Start and log in to each of the Replication Agent for Microsoft SQL Server 15.7.1 SP100 instances and:
1. Set the rs_charset configuration parameter to match the Replication Server character set, as described in the Replication Agent Reference Manual.
2. Use the test_connection command to ensure that Replication Agent can connect to both Microsoft SQL Server and Replication Server.
3. Initialize the Replication Agent instance and migrate the Replication Agent instance's metadata by issuing the ra_migrate command.
  
  When this command executes in the first Replication Agent 15.7.1 instance, it will also initialize the Microsoft SQL Server. In subsequent Replication Agent 15.7.1 instances, it will only initialize the instance and migrate the instance metadata.
  
  Note: You can use the ra_finalize_upgrade to manually force upgrade finalization of an instance from a previous version and prevent downgrade to the previous version. You must finalize the upgrade to enable any new functionality. See the Replication Agent Reference Manual for details on using the ra_finalize_upgrade command.
Resume replication.
```
resume
```