Migration Settings Reference
Complete reference for every configuration option in DBMigrateAIPro. Settings are configured in the right panel of the desktop app or in the project config/settings.json file.
Connection Settings
RequiredConnection settings are entered separately for source (Oracle) and target (PostgreSQL). Both connections are tested before any migration step runs.
| Setting | Type | Default | Description |
|---|---|---|---|
| host | string | required | Hostname or IP address of the source/target database server |
| port | int | 1521 / 5432 | Database port — 1521 for Oracle, 5432 for PostgreSQL |
| database / service | string | required | Oracle service name / SID or PostgreSQL database name |
| username | string | required | Login username. Must have read access on Oracle, write access on PostgreSQL |
| password | string | required | Login password. Stored in encrypted project config, never in plaintext logs |
| schema | string | "" | Source schema to migrate. Empty string migrates all accessible schemas |
| ssl | boolean | false | Enable SSL/TLS for the database connection. Requires certificates to be configured |
Performance Settings
TuningThese settings control throughput and resource usage. Start with defaults and scale parallel_workers and batch_size based on observed rows/sec in the Perf tab.
| Setting | Type | Default | Description |
|---|---|---|---|
| batch_size | int | 10000 | Number of rows fetched and written per batch. Lower for memory-constrained environments |
| parallel_workers | int | 4 | Number of parallel migration threads. Valid range: 1–64. Match to CPU core count |
| poll_interval_sec | float | 5.0 | Seconds between progress updates in the Perf tab during live migration |
| memory_limit_mb | int | 2048 | Soft memory ceiling in MB. Reduces batch size automatically when approached |
| fetchmany_size | int | 5000 | Oracle cursor fetchmany() chunk size. Should be ≤ batch_size |
| bulk_method | string | "COPY" / "executemany" | PostgreSQL: COPY for maximum throughput. Other targets: executemany fallback |
Schema Options
FilterControl which database objects are included in the migration. The include_tables/ exclude_tables filters are applied before DDL conversion runs.
| Setting | Type | Default | Description |
|---|---|---|---|
| include_tables | list | [] | Allowlist of table names to migrate. Empty list means all tables are included |
| exclude_tables | list | [] | Denylist of table names to skip. Applied after include_tables filter |
| include_schema | string | "" | Migrate only objects belonging to this schema. Overrides per-connection schema setting |
| exclude_system_tables | bool | true | Skip Oracle system / data dictionary tables (SYS, SYSTEM schemas) |
| migrate_views | bool | true | Convert and recreate Oracle views as PostgreSQL views |
| migrate_sequences | bool | true | Recreate Oracle sequences as PostgreSQL sequences, synced to current value |
| migrate_indexes | bool | true | Recreate indexes after data load. Disabling speeds up load at cost of query perf |
| migrate_fks | bool | true | Recreate foreign key constraints in PostgreSQL after data load completes |
| defer_fks_during_load | bool | true | Drop FKs before data load, recreate after. Required for circular FK graphs |
CDC Configuration
Change Data CaptureCDC settings control the LogMiner (Oracle) or binlog (MySQL/MSSQL) streaming pipeline used for zero-downtime cutover. Supplemental logging must be enabled on Oracle before starting CDC.
| Setting | Type | Default | Description |
|---|---|---|---|
| source_type | string | required | Source database type for CDC. One of: oracle, mysql, mssql |
| start_scn | int | auto | Oracle LogMiner start SCN. Defaults to SCN captured at migration start if not set |
| poll_interval | float | 5.0 | Seconds between LogMiner / binlog poll cycles |
| batch_size | int | 1000 | Max change events processed per CDC poll cycle |
| supplemental_logging | bool | required | Oracle only — ALTER DATABASE ADD SUPPLEMENTAL LOG DATA must be enabled first |
| tables | list | [] | Fully-qualified table names (SCHEMA.TABLE) to capture CDC events for. Empty = all |
Oracle Prerequisite
Enable supplemental logging before capturing the start SCN:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;Validation Settings
QAValidation runs automatically after data load. Reports are written toreports/validation_report.html (or .json if configured). Enable checksum checks only when data integrity is paramount — they significantly increase validation time.
| Setting | Type | Default | Description |
|---|---|---|---|
| run_row_count_check | bool | true | Compare source vs target row counts for every migrated table after load |
| run_checksum_check | bool | false | Run MD5 checksum comparison per row. Slower but catches silent data corruption |
| checksum_columns | list | PK columns | Columns included in row checksum. Defaults to primary key columns only |
| report_format | string | "html" | Validation report output format. Accepts "html" for browser-readable or "json" for tooling |