SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-38
migrate Utility
migrate Utility
Considerations for migrate
Examples of migrate
The migrate utility is an OSS command-line utility that copies metadata from a
previous version of SQL/MX into system metadata tables of SQL/MX Release 2.x.
migrate handles full or partial migrations.
For instructions on how to migrate metadata, see the SQL/MX Installation and
Management Guide. For migrating stored procedures, see the SQL/MX Guide to
Stored Procedures in Java.
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 ]
}
]