SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-42
migrate Utility
migrate Utility
Considerations for migrate
Examples of migrate
The migrate utility is an OSS command-line utility that copies SQL/MP metadata from
SQL/MX Release 1.8 user metadata tables to SQL/MX Release 2.x system metadata
tables. migrate handles full or partial migrations of SQL/MP metadata. Use the
migrate utility immediately after installing SQL/MX Release 2.x after creating the
catalogs and schemas in the SQL/MX Release 2.x database.
For detailed instructions on how to use the migrate utility to copy SQL/MP metadata
from SQL/MX Release 1.8 to SQL/MX Release 2.x, see the SQL/MX Database and
Application Migration Guide.
The command syntax for the migrate utility is:
migrate
must be lowercase.
PRELIMINARY_REPORT
must be uppercase. It identifies discrepancies that you must resolve before
performing the EXECUTE command. You must address and resolve these
discrepancies before the migration can continue and complete successfully:
•
Catalogs and/or schemas that are referenced in NonStop SQL/MP but do not
exist in NonStop SQL/MX
•
Guardian namespace files that are referenced in NonStop SQL/MP but do not
physically exist on disk
•
Java classes or JAR files of stored procedures that are referenced in
NonStop SQL/MP but do not physically exist in OSS directories on disk
To modify or eliminate entries containing discrepancies, use the SHOW SCRIPT
and EXECUTE SCRIPT commands.
migrate
[ { PRELIMINARY_REPORT
| SHOW [ALL] [MPALIAS] [DEFAULTS] [ODBC] [PROCS]
[SCRIPT [<OSS-filename> [CLEAR]]]
| EXECUTE [{ [ALL] [MPALIAS] [DEFAULTS] [ODBC]
[PROCS] | SCRIPT <OSS-filename> } ]
[ERROR_LOG [<OSS-filename> [CLEAR]]]
| HELP [ BRIEF | DETAIL | EXAMPLE ]
}
]