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

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

  1. Connect to the user database.
    Use ExpressConnect for Oracle or Enterprise Connect™ DirectAccess (ECDA) Option for ODBC for IBM DB2 UDB and Microsoft SQL Server.
  2. Find the relevant script in the scripts subdirectory of your Replication Server installation directory and run the script with the isql -i option.
    For example, to upgrade an IBM DB2 user database, run the hds_db2_upgradedb.sql script on the user database.