Using the External Migrator

To use the External Migrator, run the following command:

./ibextmigrator options

The available External Migrator options are listed in the following table.

Option	Description
-h [ - -help]	Prints help messages.
-f [ - -force ]	Continues migration, even if an error occurs.
-v [ - -verbose ]	Shows more details.
-b [ - -pg-bin ] arg	PostgreSQL installation path.
-u [ - -pg-user ] arg	PostgreSQL user used to create the migration database.
-s [ - -src-datadir ] arg	Source MySQL datadir.
-i [ - -dst-ibdatadir ] arg	Destination Hyperstage Server datadir (ib_data).
-p [ - -dst-pgdatadir ] arg	Destination PostgreSQL datadir (pg_data).
-d [ - -dst-db ] arg	Destination PostgreSQL database name.
-t [ - -tables ] arg	List of tables to migrate in the form "db1.t1 db2.t3 db2." where implies migration of every table in the database. If not specified, the External Migrator will attempt to migrate the entire datadir.
-c [ - -dst-schema ] arg (=public)	Name of destination schema to which tables specified with the -t option should be migrated. Defaults to public.
- -connection-db arg (=template1)	Database that External Migrator will use to connect to PostgreSQL.
- -force-charset-conversion [=arg(=utf8)]	Specifying this option will turn off check if all data selected for migration has common charset and trigger conversion to specified charset (utf8 is default) if necessary. You can also use this option to trigger conversion of all data to specified charset.
- -version	Print program version number and exit.

Example:

c:\ibi\srv77\home06Hyperstage\hs\bin>ibextmigrator.exe
-b "C:\ibi\srv77\home06Hyperstage\hs\bin" -u srvadmin
-s "C:\HyperstageMySQL\Data" -p "C:\HyperstagePG\pg_data" 
-i "C:\HyperstagePG\ib_data" -d migrated 
-t "webfocus.*" --force-charset-conversion=utf8

WebFOCUS