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-21
Migrating Data From a SQL/MP Database to a
SQL/MX Database
Migrating Data From a SQL/MP Database to a
SQL/MX Database
After creating the SQL/MX database, you are ready to migrate data from SQL/MP
tables into SQL/MX tables. To avoid disrupting applications that access the SQL/MP
database, plan to migrate the data when business traffic and system demands are low.
Verifying Compatible Data Types
To prevent errors or data truncation when loading data from a SQL/MP table into a
SQL/MX table, verify that the SQL/MX table uses data types that are compatible with
the SQL/MP table. For more information, see Column Data Types
on page 5-9. If
necessary, use the DROP TABLE statement and then the CREATE TABLE statement
to change the column to a compatible data type. For more information about these
statements, see the
SQL/MX Reference Manual.
Selecting a Data Movement Tool
Select the data movement tool that is most appropriate. Table 5-8 shows these tools
and their usefulness with respect to important database migration criteria.
To use the following tools to copy data from a SQL/MP database to a SQL/MX
database, see:

Using INSERT-SELECT to Copy Data on page 5-22

Using DataLoader/MX to Copy Data on page 5-22

Using Third-Party Data Replication Tools on page 5-25
Table 5-8. Selecting a Data Movement Tool
Selection Criteria
INSERT-SELECT
Statements DataLoader/MX
Third-Party Data
Replication
Tools
Large, complex database X X
Small, simple database X
Online migration is required X
Offline migration is
acceptable
XX
Moves static data X X X
Moves dynamic data X
Audits non-audited data and
moves it
X