Seagate ST43401N/ND Informations techniques télécharger pdf (Page 161)

Migrating to Sybase Adaptive Server Enterprise 11.5 D-17

Adaptive Server Enterprise 11.5 Staged Cutover Task Overview

5. Upgrade the production system to Release 11.5.

6. Run

dbcc commands (checktable,checkalloc, checkcatalog) on the Release

11.5 databases. Be sure to verify the

dbcc log and error log.

7. “Baseline” the Release 11.5 conﬁguration on the production

system.

8. Perform user testing and veriﬁcation.

Perform Final Steps

1. Start production users on the Release 11.5 production system.

2. Upgrade the test system to Release 11.5.

Staged Cutover Task Overview

This sample task overview covers a staged cutover migration

approach to rebuild SQL Server. The scenario for this task list is:

• The large company has a mature client/server environment with

multiple applications residing on a single SQL Server.

• In the event of failure, the company depends on nightly backups

and transactions dumps. The system cannot be down more than

one hour and cannot afford more than two hours of data loss.

• The environment includes development, test, and production

platforms. It requires enough space for duplicate servers on each

platform.

• The object-level rebuild strategy necessitates moving the data,

which requires system downtime for the target application.

Tasks

The high-level tasks in this scenario are:

1. Conﬁgure Adaptive Server 11.5 on the development system,

duplicating the SQL Server 10.x development conﬁguration.

2. Migrate the development objects to the Release 11.5

development system.

3. Construct regression test suites.

4. Construct

bcp scripts to move object deltas.

5. “Baseline” the Release 10.x test environment.

1 2 ... 156 157 158 159 160 161 162 163 164 165 166 ... 171 172

Pas de commentaire

Seagate ST43401N/ND Informations techniques Page 161