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

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4
6. Falling Back to NonStop SQL/MP
Converting SQL/MP Tables to SQL/MX Tables 5-1
ANSI Compliance
5-2
New Functionality in NonStop SQL/MX
5-2
Enabling SQL/MX Applications to Access Specific Tables
5-2
Size of the Database Object
5-3
Reasons for Keeping SQL/MP Tables
5-3
Differences Between SQL/MP and SQL/MX Databases
5-4
System Catalogs and Metadata
5-5
User Catalogs and Schemas
5-5
Database Object Names
5-6
Distributed Database Objects
5-7
Database Object Security
5-7
Tables
5-8
Partitions
5-11
Indexes
5-11
Views
5-13
Collations
5-13
SQL/MX DDL Statements and Utilities
5-14
SQL/MX DDL Statements
5-14
SQL/MX Utilities
5-16
Steps for Converting
a SQL/MP Database to SQL/MX Tables 5-20
Migrating Data From
a SQL/MP Database to a SQL/MX Database 5-21
Verifying Compatible Data Types
5-21
Selecting a Data Movement Tool
5-21
Using INSERT-SELECT to Copy Data
5-22
Using DataLoader/MX to Copy Data
5-22
Using Third-Party Data Replication Tools
5-25
Updating Table Statistics
5-25
6. Falling Back to NonStop SQL/MP
Steps for Falling Back to NonStop SQL/MP 6-1