Command Builder

Build your MigratorXpress command step by step using the interactive wizard below.

Expand All

Platform Linux

Linux

Windows (PowerShell)

Source Database

Authentication File:
Source Database ID (required):	ID from your credentials JSON file
Source Schema Name:	Supports SQL LIKE patterns (%, _). Comma-separated for multiple. Omit for all schemas. Not used with Resume.

Target Database

Target Database ID (required):	ID from your credentials JSON file. SQL Server or PostgreSQL target (PostgreSQL: names are lower-cased, no copy_fk; not from a Netezza source)
Target Database Name (optional):	Defaults to the database of the target entry in the credentials file. If set, it must match it.
Target Schema Name:	Leave empty to keep the source schema name(s). If set with a pattern/list (or no source schema), all source schemas are loaded into this single schema.

Migration Tracking Database

Migration DB ID (required):	SQL Server or PostgreSQL database for migration tracking and logging
Migration DB Mode:	preserve truncate drop preserve: keep tracking data (enables resume). truncate: delete all tracking data (all runs). drop: recreate all tracking tables.

Migration Tasks translate, create, transfer, diff

translate — Translate source column types to target types

create — Create tables in target database

transfer — Copy data (requires FastTransfer)

diff — Validate data integrity

copy_pk — Copy primary key constraints

copy_ak — Copy alternate key constraints

copy_fk — Copy foreign key constraints

Tasks always run in this order. copy_pk/copy_ak/copy_fk need an Oracle, PostgreSQL or SQL Server source (not Netezza). copy_fk, and so "all", needs a SQL Server target.

FastTransfer Configuration

Table Filtering

Migration Options

Oracle Source Options

Logging & Output

Resume

License

Generated Command

Multi-line

./MigratorXpress \
  --auth credentials.json \
  --source_db_auth_id <source_db_auth_id> \
  --target_db_auth_id <target_db_auth_id> \
  --migration_db_auth_id <migration_db_auth_id> \
  --task_list translate create transfer diff