Upgrading Sybase Servers

This chapter describes how to upgrade approved versions of Adaptive Server, SQL Server, Backup Server, and Monitor Server to version 12.5.

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

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

Preparing database and devices

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

Restoring replication after upgrade

Upgrading to Adaptive Server 12.5

Using sqlupgrade

Using sqlupgraderes

Post-upgrade tasks

Verifying that servers are running

Restore functionality in Adaptive Server

Reenabling replication server

Reenabling 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

Upgrading compiled objects in database dumps

Determining whether a compiled object has been upgraded

Recovering from a failed upgrade


	Expand Search