SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

HP NonStop SQL/MX Installation and Management Guide—523723-004
14-1
14
Migrating an SQL/MP Database to
NonStop SQL/MX Release 2.1 or
Release 2.0
This section describes how to migrate SQL/MP data from an SQL/MP or NonStop
SQL/MX Release 1.8 environment to Release 2.1 or Release 2.0. The procedures in
this section include steps to increase the success of fallback, if falling back is
necessary. Appendix A, Falling Back From NonStop SQL/MX Release 2.1 or Release
2.0 contains fallback information.
This section addresses these topics:
•
Migration Basics on page 14-1
•
Planning for Migration on page 14-2
•
Migrating an SQL/MP Database to Release 2.1 or Release 2.0 Using MP Tables
on page 14-4
•
Migrating an SQL/MP Database to Release 2.1 or Release 2.0 Using SQL/MX
Tables on page 14-4
•
Using the migrate Utility to Migrate SQL/MP Metadata From Release 1.8 on
page 14-5
•
Migrating an Enscribe Database to Release 2.1 or Release 2.0 Using SQL/MX
Tables on page 14-14
•
Migrating an Enscribe Database to Release 2.1 or Release 2.0 Using SQL/MX
Tables on page 14-14
•
Tools for Migrating Data on page 14-15
Migration Basics
To help you understand migration in general and the procedures presented in this
section, note that:
•
Release 2.1 and Release 2.0 require G06.23 or a later RVU and are not supported
on pre-G06.23 RVUs.
•
Release 2.1 and Release 2.0 require processors that support IEEE floating-point
functions. All processors in a node on which Release 2.1 or Release 2.0 is
installed must be Model 1954 (S72000) or later. A processor halt %005101 can
result if one or more processors in a system do not meet the minimum hardware
requirements for installing Release 2.1 or Release 2.0.