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

Converting an SQL/MP Database to SQL/MX Tables
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
11-21
Steps for Converting an SQL/MP Database to
SQL/MX Tables
Steps for Converting an SQL/MP Database to
SQL/MX Tables
To convert an SQL/MP database to SQL/MX tables:
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 an 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 an 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
details, see Section 10, Converting SQL/MP Applications to SQL/MX Applications
.
4. Load data from the SQL/MP tables into the SQL/MX tables. For details, see
Migrating Data From an SQL/MP Database to an SQL/MX Database
on
page 11-22.
5. Create indexes for the SQL/MX tables.
6. Update the table statistics.
For details, see Updating Table Statistics
on page 11-26.
7. Compile the SQL/MX applications that access the SQL/MX database.
For details, see Compiling the Application
on page 10-54.
8. Start running the applications.