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

Converting SQL/MP Tables to SQL/MX Tables
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
5-20
Steps for Converting a SQL/MP Database to
SQL/MX Tables
Steps for Converting a SQL/MP Database to
SQL/MX Tables
To convert a SQL/MP database to SQL/MX tables, complete the following steps:
1. Plan and design the database, and determine a strategy for table and index
partitions, security, TMF, and recovery mechanisms.
For more information about planning a SQL/MX database, see the
SQL/MX
Installation and Management Guide.
2. Create the SQL/MX database:
a. Create the user catalogs.
b. Create the schemas.
c. Create the SQL/MX tables.
d. Create views, triggers, and stored procedures if desired.
e. Grant privileges on the SQL/MX database objects to users.
For more information about creating a SQL/MX database, see the
SQL/MX
Installation and Management Guide.
3. Convert the source code of your SQL/MP applications to NonStop SQL/MX. For
more information, see Section 4, Converting SQL/MP Applications to SQL/MX
Applications.
4. Load data from the SQL/MP tables into the SQL/MX tables. For more information,
see Migrating Data From a SQL/MP Database to a SQL/MX Database
on
page 5-21.
5. Create indexes for the SQL/MX tables.
6. Update the table statistics.
For more information, see Updating Table Statistics
on page 5-25.
7. Compile the SQL/MX applications that access the SQL/MX database.
For more information, see Compiling the Application
on page 4-53.
8. Start running the applications.