Upgrading Non-SAP ASE User Databases and User Databases Not Supported by sysadmin upgrade

Use the corresponding upgrade scripts for databases such as IBM DB2 UDB, and Microsoft SQL Server that are not supported by the sysadmin upgrade, database command and rs_init.

1. Use the maintenance user login ID to connect to the user database.
   See the SAP Replication Server Options documentation to configure a connection to a non-SAP ASE database.
2. Find the relevant script in the scripts subdirectory of your SAP Replication Server installation directory.
   The scripts are named hds_dataserver_make_upgradedb.sql where dataserver_make is the replicate data server type.
3. Run the script to upgrade the user database.

   Modify or run the script unchanged depending on the way SAP Replication Server connects to the user database.

   If the connection is through, Enterprise Connect™ Data Access (ECDA) runs the script unchanged. For example, to upgrade an IBM DB2 UDB user database, use ECDA for ODBC with the isql -i option to run the hds_db2_upgradedb.sql script on the user database.