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.
- Use the
maintenance user login ID to connect to the user database.
See the Replication Server Options documentation to configure
a connection to a non-ASE database.
- Find the relevant script in the scripts subdirectory of your Replication Server installation
directory.
The scripts are named
hds_dataserver_make_upgradedb.sql
where dataserver_make is the replicate data server
type.
- Run the script to upgrade the user database.
Modify or run the script
unchanged depending on the way Replication Server connects to the user
database. If the connection is through:
- Enterprise Connect™ Data Access (ECDA) – run 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.
- ExpressConnect – modify the script to allow the tool of your
choice to run it. For example, to upgrade an Oracle database,
remove the go commands in the
hds_oracle_upgradedb.sql script and load the
script manually .