SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Overview of SQL/MX Migration
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
1-19
Guidelines for Conducting the Migration
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 Possible Migration Paths to NonStop SQL/MX
on
page 1-2 and Planning for Migration
on page 1-9.
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 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.
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 questions such as:
•
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?
Plan for fallback
•
Section 4, Falling Back to an Earlier Version of
SQL/MX Release 2.x
•
Section 8, Falling Back to SQL/MX Release 1.8
•
Section 12, Falling Back to NonStop SQL/MP
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-19
Migration Plan For more information, see...