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-15
Choosing Which Database Applications and
Database Objects to Migrate
Choosing Which Database Applications and Database Objects to
Migrate
After determining your business objectives and assessing your current application and
database environment, choose which applications and database objects to migrate to
NonStop SQL/MX. Use Table 1-10
and Table 1-11 on page 1-16 to gather information
that will help you determine which applications and database objects to migrate to
NonStop SQL/MX.
Number of SQL/MX tables
For each database table:
File size
Number of partitions
Primary keys
Columns
Indexes
Number of views
Information about table statistics
Table 1-10. Choosing Which Database Applications to Migrate (page1of2)
Obtain this information
Identify and prioritize the applications to move to NonStop SQL/MX.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
For each high-priority application:
Is the application mission-critical?
Table 1-9. Database (page 2 of 2)
Obtain this information