7.1 Offline Migration

Table of Contents Previous Next


7 Migration Toolkit Command Options : 7.1 Offline Migration

If you specify the -offlineMigration option in the command line, Migration Toolkit performs an offline migration. During an offline migration, Migration Toolkit reads the definition of each selected object and creates an SQL script that, when executed at a later time, replicates each object in Postgres.
To perform an offline migration of both schema and data, specify the ‑offlineMigration keyword, followed by the schema name:
$ ./runMTK.sh -offlineMigration file_dest schema_name
To perform an offline migration of schema objects only (creating empty tables), specify the ‑schemaOnly keyword in addition to the ‑offlineMigration keyword when invoking Migration Toolkit:
To perform an offline migration of data only (omitting any schema object definitions), specify the ‑dataOnly keyword and the ‑offlineMigration keyword when invoking Migration Toolkit
By default, data is written in COPY format; to write the data in a plain SQL format, include the ‑safeMode keyword:
$ ./runMTK.sh -offlineMigration -dataOnly -safeMode schema_name
Please note: the -singleDataFile option is available only when migrating data in a plain SQL format; you must include the -safeMode keyword if you include the ‑singleDataFile option.

7 Migration Toolkit Command Options : 7.1 Offline Migration

Table of Contents Previous Next