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

Contents
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
vii
10. Converting SQL/MP Applications to SQL/MX
Applications (continued)
10. Converting SQL/MP Applications to SQL/MX
Applications (continued)
Steps for Moving an Application to Production 10-61
11. Converting an SQL/MP Database to SQL/MX Tables
Why Convert SQL/MP Tables to SQL/MX Tables? 11-1
ANSI Compliance 11-2
New Functionality in NonStop SQL/MX 11-2
Enabling SQL/MX Applications to Access Specific Tables 11-2
Size of the Database Object 11-3
Reasons for Keeping SQL/MP Tables 11-3
Differences Between SQL/MP and SQL/MX Databases 11-4
System Catalogs and Metadata 11-5
User Catalogs and Schemas 11-6
Database Object Names 11-6
Distributed Database Objects 11-7
Database Object Security 11-7
Tables 11-8
Partitions 11-11
Indexes 11-12
Views 11-13
Collations 11-14
SQL/MX DDL Statements and Utilities 11-14
SQL/MX DDL Statements 11-14
SQL/MX Utilities 11-16
Steps for Converting an SQL/MP Database to SQL/MX Tables 11-21
Migrating Data From an SQL/MP Database to an SQL/MX Database 11-22
Verifying Compatible Data Types 11-22
Selecting a Data Movement Tool 11-22
Using INSERT-SELECT to Copy Data 11-23
Using DataLoader/MX to Copy Data 11-23
Using Third-Party Data Replication Tools 11-26
Updating Table Statistics 11-26
12. Falling Back to NonStop SQL/MP
Steps for Falling Back to NonStop SQL/MP 12-1
Index