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

HP NonStop SQL/MX Release 3.1 Database and Application Migration Guide—663853-001

2-1

2 Considerations for upgrading

to SQL/MX Release 3.1

If you are currently using SQL/MX, to obtain new functionalities, performance

enhancements, and bug fixes, you might want to upgrade to a newer version.

This section discusses the factors that you must consider before upgrading to SQL/MX

Release 3.1, and addresses the following topics:



Migration path on page 2-1



Compatibility of SQL/MX 3.1 systems on page 2-1



Working with v3100, v3000, and v1200 objects in SQL/MX Release 3.1 on

page 2-3



Conversions from numeric to char or varchar on page 2-3



New features in SQL/MX Release 3.1 on page 2-5



New metadata in SQL/MX Release 3.1 on page 2-6

Migration path

You can migrate from SQL/MX Release 2.3.x or SQL/MX Release 3.0 to SQL/MX

Release 3.1, as shown in Figure 2-1.

Compatibility of SQL/MX 3.1 systems

SQL/MX Release 3.1 can coexist only with other instances of SQL/MX Release 3.1 in

a network, as shown in Figure 2-2.

Figure 2-1. Migration Path from SQL/MX 2.3.x or SQL/MX 3.0 to SQL/MX 3.1

SQL/MX

R2.3.x

SQL/MX

R3.1

R3.0