SQL/MX 3.1 Database and Application Migration Guide (H06.23+, J06.12+)

Overview of SQL/MX Migration
HP NonStop SQL/MX Release 3.1 Database and Application Migration Guide—663853-001
1-2
Guidelines for conducting the migration
If the migration can be broken into phases, each phase must include its own complete
plan:
Guidelines for conducting the migration
To ensure a successful migration, use the following guidelines:

Conducting the initial migration in a test environment

Runing baseline tests and gathering data at each migration phase

Assessing the success of the migration
Conducting the initial migration in a test environment
To avoid disrupting the production database and daily business operations, isolate key
applications and database objects to migrate and conduct the initial migration in a test
environment. The test environment should simulate the production environment as
much as possible.
Runing baseline tests and gathering 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.
Assessing the success of the migration
The data that you gather during each migration phase will help you determine the
success of migration. Prepare 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 applications

Section 4, Upgrading to SQL/MX Release 3.1
Plan for fallback

Section 5, Falling Back from SQL/MX Release
3.1
Plan for updating disaster recovery or
RDF configuration and procedures

SQL/MX Installation and Management Guide
Plan for validating that migration is
successful

Guidelines for conducting the migration on
page 1-2