MX 3.0 Database and Application Migration Guide (H06.22+, J06.11+)

Overview of SQL/MX Migration

HP NonStop SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide—666210-002

1-3

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. 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?