
D-14 Sample Migration Task Lists
Cutover Migration Task List Example Adaptive Server Enterprise 11.5
Define Test/Acceptance Criteria—Regression Test Suites
Front-end simulation regression test suite
1. Identify target user functions.
2. Capture and map SQL for target user functions.
3. Encapsulate SQL for user functions.
4. Create front-end simulated test suite (
showplan, stat io, and stat time
wrappers).
Front-end regression test suite
1. Identify front-end test scenarios.
2. Understand front-end application and acceptance/test
procedures.
3. Document functional test approach.
4. Compose front-end test mix matrix.
Define Release 11.5 to 10.x Fallback Procedures on Test System
1. Create the fallback scripts to re-create the Release 10.x
environment.
2. Document fallback procedures.
“Baseline” Release 10.x Environment on Test System
Recycle SQL Server 10.x.
Run Regression Test Suites on Release 10.x Test System
Front-end simulation regression test suite
1. Iteratively perform front-end simulation regression testing.
2. Monitor and capture system dynamics (
sp_who, sp_lock...).
3. Verify and document this SQL Server 10.x regression test.
Comentarios a estos manuales