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-22
Migrating Data From an SQL/MP Database to an
SQL/MX Database
Migrating Data From an SQL/MP Database to
an 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 an SQL/MP table into an
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 11-10. 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 for your needs. Table 11-8
shows these tools and their usefulness with respect to important database migration
criteria.
To use these tools to copy data from an SQL/MP database to an SQL/MX database,
see:
•
Using INSERT-SELECT to Copy Data on page 11-23
•
Using DataLoader/MX to Copy Data on page 11-23
•
Using Third-Party Data Replication Tools on page 11-26
Table 11-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 nonaudited data and
moves it
X