SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Migrating an SQL/MP Database to NonStop SQL/MX
Release 2.1 or Release 2.0
HP NonStop SQL/MX Installation and Management Guide—523723-004
14-13
Steps for Migrating ODBC Metadata From Release
1.8 to Release 2.1 or Release 2.0
2. To determine which system-level default settings exist in the ODBC metadata
tables in the SQL/MP system catalog, use the SHOW ODBC command of the
migrate utility and direct this information to a file:
/usr/tandem/sqlmx/bin: migrate SHOW ODBC > odbc_info.out
The command displays this result:
3. Migrate ODBC entries from SQL/MP metadata to SQL/MX metadata by using the
EXECUTE command of the migrate utility.
•
To migrate all entries from the ODBC metadata tables, enter:
/usr/tandem/sqlmx/bin: migrate EXECUTE ODBC
ERROR_LOG odbc_errors.out CLEAR
•
To migrate only ODBC entries in the script file, enter:
/usr/tandem/sqlmx/bin: migrate EXECUTE SCRIPT
odbc_script.out
ERROR_LOG odbc_errors.out CLEAR
If you do not specify the name and OSS location of the error log file, the default is
error_log.out in the current directory. If you specify an existing error log file,
use the CLEAR option to direct the migrate utility to clear the contents of the file
before adding information about migration errors. If the error log file already exists
and you omit the CLEAR option, the migrate utility uses error_log.out.
4. Examine and resolve errors in the error log file. The migrate EXECUTE command
captures information about the metadata entries that fail to migrate to Release 2.1
or Release 2.0 and logs the information in the error log file. Fix the errors in a script
file and run the migrate EXECUTE SCRIPT command to migrate previously failed
metadata. See Steps 2 and 3.
Hewlett-Packard Nonstop (TM) SQL/MX Metadata Migration Utility 2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
SHOW: The following ODBC tables exist in the MP catalog...
ZONAM2ID
ZOAS2DS
ZODS
ZOENV
ZORES
--------------------------------------------------------------------
SHOW: Summary of Show Scan.
ODBC entries available for migration.
--------------------------------------------------------------------------
Note. Because there are no discrepancies to report for the NonStop ODBC metadata tables, it
is not necessary to use the PRELIMINARY_REPORT command to display discrepancies. Use
the SHOW SCRIPT command to generate a script file for editing purposes.