Quick Start

Quick Start Guide

Run your first Oracle → PostgreSQL migration in under 5 minutes. DBMigrateAIPro is a self-contained desktop app — no cloud account, no Docker, no infrastructure setup required.

1

Installation

DBMigrate AI Pro is a desktop application that runs on your machine. Requires Python 3.12+ on Windows, macOS, or Linux. Three commands to get running:

git clone https://github.com/rakeshmamidaladba/migret.git
cd migret
pip install -r requirements.txt
python main.py

Prefer a release zip? Grab the latest tagged release from GitHub Releases, extract, then pip install -r requirements.txt and python main.py.

The app launches in Hobby mode by default — free forever, with a 5-table / 2-worker / 3-connector limit. To unlock all 12 connectors, CDC, the AI Advisor, the Scheduler, and the DDL export bundle, click the HOBBY badge in the top-right corner of the app, paste your Pro license key, and restart.

2

Create a Project

When the app starts, click New Project on the canvas. Enter a project name and destination folder. DBMigrateAIPro automatically creates a 15-folder project structure so every artifact has a home:

01_assessment/
02_schema_ddl/
03_code_objects/
04_data_migration/
05_validation/
06_final_summary/

All migration outputs — DDL scripts, data exports, validation reports, logs — are written into these folders automatically.

3

Connect Source & Target

In the right panel, open the Actions tab. Enter your Oracle connection details:

Host
oracle-server.example.com
Port
1521
Service / SID
ORCL
Username
migration_user
Password
••••••••

Click Test Connection — a green checkmark confirms connectivity. Repeat for your PostgreSQL target.

4

Assess Schema

Click Assess Schema to generate a risk report before running any migrations. The assessment scans your Oracle schema for:

  • XMLTYPE columns — not directly portable to PostgreSQL
  • Partitioned tables — partition strategy must be re-declared
  • Circular foreign key dependencies — require deferred loading
  • Unsupported PL/SQL constructs — CONNECT BY, ROWNUM, BULK COLLECT
  • Object counts — tables, views, sequences, indexes, packages, triggers

The report is saved to reports/assessment_report.html. Review it before proceeding.

5

Run Migration

Open the Tables tab in the right panel. Select the tables you want to migrate — or check Select All for the full schema. Then click Migrate.

Rows/sec

Live in Perf tab

Progress

Per-table progress bar

Errors

Logged to logs/

DBMigrateAIPro uses parallel workers and PostgreSQL COPY for maximum throughput. Default batch size is 10,000 rows.

6

Validate Results

After migration completes, DBMigrateAIPro automatically runs a validation pass. Comparison reports appear in the reports/ folder with:

Row Count Comparison

Source vs target row counts per table — any discrepancy is flagged

Checksum Validation

Optional MD5 hash comparison per row — slower but catches data corruption

Sequence Sync

Oracle sequences are reset to the correct next value in PostgreSQL

FK Integrity

Foreign key constraints re-enabled and validated after load completes