SQL/MP to SQL/MX Database and Application Migration Guide

Overview
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
1-10
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
Test scripts identified by their
application
Test drivers and other related
programs identified by their
application
Test data and test databases
identified by their application
Table 1-7. Database
Obtain this information
Databases and data files that are
candidates for migration. Provide
high-level information about:
Size
Location
Performance
Release of NonStop SQL/MP on the
system
Number of SQL/MP tables
Release of NonStop SQL/MX
installed on the system
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-6. Testing Environment (page 2 of 2)
Obtain this information