Seagate ST43401N/ND Informacje Techniczne Pobierz pdf (Strona 157)

Migrating to Sybase Adaptive Server Enterprise 11.5 D-13

Adaptive Server Enterprise 11.5 Cutover Migration Task List Example

Cutover Migration Task List Example

This sample task list covers a cutover migration approach to upgrade

SQL Server 10.x to Adaptive Server 11.5. The scenario for this task list

is:

• The mid-sized company requires a simple, somewhat fault-

tolerant upgrade.

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

The system cannot be down more than one hour and cannot

afford more than eight hours of data loss.

• The environment includes development, test, and production

systems.

This example does not repeat the preparation steps given in previous

examples.

Set Up Adaptive Server 11.5 Environment on Development System

1. Conﬁgure the physical drives and local array, duplicate the

environment of the Release 10.x development system.

2. Perform a dump of the Release 10.x development system.

3. Install Adaptive Server 11.5.

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

duplicating the Release 10.x development environment.

5. Update the interfaces ﬁle.

6. Create the databases on Adaptive Server 11.5.

7. Load the dump of the Release 10.x development system.

8. Run

dbcc commands (checktable, checkalloc, checkcatalog) on Adaptive

Server 11.5 databases. Be sure to verify the

dbcc log and error log.

9. Synchronize user IDs between the Release 10.x and 11.5

development systems.

10. Run

checkpoint on the Release 11.5 environment.

11. Shift development to Adaptive Server 11.5. Developers begin

veriﬁcation and new feature development.

1 2 ... 152 153 154 155 156 157 158 159 160 161 162 ... 171 172

Brak uwag

Seagate ST43401N/ND Informacje Techniczne Strona 157