SQL/MX 3.1 Database and Application Migration Guide (H06.23+, J06.12+)

Hewlett-Packard Company—663853-001
i
HP NonStop SQL/MX Release
3.1 Database and Application
Migration Guide
Index Figures Tables
Legal Notices 1
What’s New in This Manual 3
Manual Information
3
New and Changed Information
3
About This Manual v
Audience v
What This Manual Does Not Cover v
Organization vi
Related Documentation vi
Notation Conventions viii
1. Overview of SQL/MX Migration
Migration Terminology 1-1
Planning for Migration 1-1
Guidelines for Conducting the Migration 1-2
Conduct the Initial Migration in a Test Environment 1-2
Run Baseline Tests and Gather Data at Each Migration Phase 1-2
Assess the Success of the Migration
1-2
Assistance With Migration 1-3
Product Support for NonStop Servers
1-3
NonStop Solutions Development and Implementation
1-3
2. Considerations for upgrading to SQL/MX Release 3.1
Migration path 2-1
Compatibility of SQL/MX 3.1 systems 2-1
Working with v3100, v3000, and v1200 objects in SQL/MX Release 3.1 2-3
Conversions from numeric to char or varchar 2-3
New features in SQL/MX Release 3.1 2-5
New metadata in SQL/MX Release 3.1
2-6
3. Version Management and Interoperability
NonStop SQL/MX releases 3-1