Upgrading Sybase Servers

This chapter describes how to upgrade approved versions of Adaptive Server, Backup Server, and Monitor Server to version 12.5, and describes how to upgrade an Adaptive Server installation built on 32-bit Adaptive Server to run on a 64-bit Adaptive Server.

If you are migrating applications from one version of jConnect to another, see Chapter 5, "Migrating jConnect Applications," in the jConnect for JDBC Programmer's Reference for instructions.

Overview of the upgrade process

System catalog changes during upgrade

Pre-upgrade tasks

Check system and upgrade requirements

Check RUN_server file location

Test current applications and stored procedures

Reserved words

Verify that users are logged off

Check database integrity

Back up databases

Dump transaction logs

Prepare the database and devices for the upgrade

Turn off database options

Preparing to upgrade servers with replicated databases

Suspending transaction processing and replication activities

Draining the transaction logs for primary databases

Draining the RSSD Transaction Log

Disabling the secondary truncation point

Upgrading to Adaptive Server 12.5

Using sqlupgrade

Using sqlupgraderes

Post-upgrade tasks

Verify that servers are running

Restore functionality in Adaptive Server

Reenable Replication Server

Reenable auditing

Upgrading Backup Server, Monitor Server, and XP Server

Upgrading compiled objects with dbcc upgrade_object

Finding compiled object errors before production

Using dbcc upgrade_object

Using database dumps in upgrades

Determining whether a compiled object has been upgraded

Migrating from 32-bit to 64-bit versions

Recovering from a failed upgrade


	Expand Search