Seagate ST43401N/ND Technické informace stáhnout pdf (Strana 148)

D-4 Sample Migration Task Lists

General Migration Task List Example Adaptive Server Enterprise 11.5

Prepare Applications For Migration

1. Search for new reserved words.

2. Search for subqueries.

3. Verify new database conversion and computations.

4. Search for

set, arithabort, and arithignore.

5. Search for select into with NULL column headings.

6. Design code changes.

7. Get user signoff on application changes.

Design and Develop Server Migration Scripts

1. Design and develop server conﬁguration scripts.

2. Design and develop ﬁle system conﬁguration for devices.

3. Create database device scripts.

4. Prepare security, login, and password corrections.

5. Create security scripts.

Design and Develop Database Migration Scripts

1. Create database scripts.

2. Create database object creation scripts.

3. Create database security scripts.

4. Modify/create system administration scripts.

Design and Develop Data Migration Scripts

1. Design and develop data extract scripts (such as

bcp).

2. Determine optimal bulk copy options.

3. Design and develop data load scripts.

Perform Other Pre-migration Tasks

1. Design fallback tasks.

2. Obtain user signoff on fallback tasks.

3. Perform backups.

1 2 ... 143 144 145 146 147 148 149 150 151 152 153 ... 171 172

Žádné komentáře

Seagate ST43401N/ND Technické informace Strana 148