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.
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.pyPrefer 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.
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:
All migration outputs — DDL scripts, data exports, validation reports, logs — are written into these folders automatically.
Connect Source & Target
In the right panel, open the Actions tab. Enter your Oracle connection details:
Click Test Connection — a green checkmark confirms connectivity. Repeat for your PostgreSQL target.
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.
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.
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
Next Steps
Dig deeper into each phase of the migration lifecycle: