SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide (H06.22+, J06.11+)

HP NonStop SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide—666210-002
2-1
2 Considerations for upgrading
to SQL/MX Release 3.0
This section discusses the factors that you must consider before upgrading to SQL/MX
Release 3.0. This section addresses the following topics:

Migration and fallback paths on page 2-1

Compatibility of SQL/MX 3.0 systems on page 2-2

Migrating applications on page 2-4

Migrating databases on page 2-4

Upgrading sequence on page 2-4

Working with v3000 and v1200 objects in SQL/MX Release 3.0 on page 2-7

Conversions from numeric to char or varchar on page 2-7

Using the read-only transaction access mode on page 2-10
Migration and fallback paths
This section describes the supported migration and fallback paths.

Migrating from SQL/MX Release 2.3.x to SQL/MX Release 3.0:
You can migrate from SQL/MX 2.3.x to SQL/MX Release 3.0, as shown in
Figure 2-1.

Falling back to SQL/MX Release 2.3.4:
You can fall back from SQL/MX Release 3.0 to SQL/MX Release 2.3.4, as shown
in Figure 2-2
.
Figure 2-1. Migration Path
SQL/MX
R2.3.x
SQL/MX
R3.0