Interactive Command Builder

Build your MigratorXpress command interactively by filling in the form below.

Fill in the required fields and optional parameters as needed. The command will be generated automatically at the bottom.

Authentication

Credentials File Path * Path to your JSON credentials file

Source Database

Source Database Auth ID * ID from your credentials file

Source Database Name *

Source Schema Name Optional - if not specified, MigratorXpress will loop over all user schemas in the source database

Target Database

Target Database Auth ID * ID from your credentials file

Target Database Name *

Target Schema Name Optional - if not specified, uses the source schema name as target schema name

Migration Database

Migration Database Auth ID * Database for tracking migration progress

Performance Options

Number of Jobs Parallel jobs for processing (default: 1)

FastTransfer Parallel Threads Parallel threads for data transfer (default: 1)

FastTransfer Directory Path Path to FastTransfer binary directory (required for data transfer tasks)

FastTransfer Large Table Threshold Threshold for big tables to be treated in parallel (default: 250,000,000)

Without Transaction ID Do not use transaction ID in Netezza or Oracle

Resume and Run Control

Resume Run ID Resume jobs given a run_id (optional)

Force Migration Force migration by cleaning all rows relating to specified source/target schemas

SQL Server Columnstore Options

Clustered Columnstore Index Threshold Create CCI if row count is above this threshold (default: 1000000)

Archive Columnstore Index Threshold Create ACI if row count is above this threshold (default: 100000000)

Table Filtering

Include Tables Pattern SQL patterns for tables to include (comma-separated, default: %)

Exclude Tables Pattern SQL patterns for tables to exclude (comma-separated)

Minimum Rows Exclude tables with fewer rows (default: -1, no limit)

Maximum Rows Exclude tables with more rows (default: -1, no limit)

Oracle-Specific Options

Forced Integer ID Prefixes Column name prefixes to force int type in Oracle (space-separated)

Forced Integer ID Suffixes Column name suffixes to force int type in Oracle (space-separated)

Profiling Options

Profiling Sample Percentage Percentage of rows to sample for profiling (default: 10%)

Minimum Sample Profile Threshold Minimum row count for applying sampling in Oracle profiling (default: 100,000)

Query Parallelism Inner level of query parallelism (default: 6)

Data Validation

Compute Number of Rows Compute exact number of table rows

Basic Diff Basic diff: column count and row count only

Foreign Key Options

Foreign Key Mode Foreign key enforcement mode

Logging Options

Log Level Logging level

Log Directory Directory for log files (default: current working directory)

Tasks to Execute

Select Tasks *

Translate Schema Create Tables Transfer Data Validate Data (Diff) Copy Primary Keys Copy Alternate Keys Copy Foreign Keys

Tasks will be executed in the order shown

Additional Options

Drop Tables if Exists Drop target tables before creating them

Migration Database Mode How to handle migration tracking data

Platform Selection

Select Platform *

Windows (PowerShell) Linux

Generated Command

Fill in the form above and click "Generate Command"