MX Database and Application Migration Guide

Overview

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001

1-14

Guidelines for Conducting the Migration

If the migration is broken into phases, each phase must include its own complete plan.

Guidelines for Conducting the Migration

After choosing a migration path and the applications or database objects to migrate,

you are ready to conduct the migration. If you have not decided which applications or

database objects to migrate, see Migrating from NonStop SQL/MP to NonStop

SQL/MX on page 1-2 and Planning for Migration on page 1-4.

To ensure a successful migration, follow these guidelines:



Conduct the Initial Migration in a Test Environment



Run Baseline Tests and Gather Data at Each Migration Phase



Assess the Success of the Migration

Conduct the Initial Migration in a Test Environment

To avoid disrupting the production database and daily business operations, isolate the

key applications and database objects to migrate and conduct the initial migration in a

test environment. The test environment must simulate the production environment as

much as possible.

Run Baseline Tests and Gather Data at Each Migration Phase

Before you migrate, use Measure to obtain initial baseline data, such as average query

run time, CPU time, and process time. At each phase of the migration, gather the same

type of data and analyze it. For more information about Measure, see the Measure

User’s Guide.

Assess the Success of the Migration

The data that you gather during each migration phase will help you determine the

success of migration. Be prepared to answer the following questions:



What did functional, performance, and scalability testing reveal during migration?



How can you use these results to improve and fine-tune the migration process

before migrating applications and database objects in the production environment?

Migration Plan For more information, see...

Plan for migrating databases Section 3, Preparing to Migrate From NonStop

SQL/MP to NonStop SQL/MX

Plan for fallback Section 6, Falling Back to NonStop SQL/MP

Plan for updating disaster recovery or

RDF configuration and procedures

Planning Database Security and Recovery in the

SQL/MX Installation and Management Guide

Plan for validating that migration is

successful

Guidelines for Conducting the Migration

page 1-14