Does Database Migration Studio require Docker to run?
No. Desktop and CLI users install a standalone native binary without Docker. Docker Compose is used only in CI integration tests against real MySQL, MariaDB, and PostgreSQL containers.
Run compatibility checks, generate versioned migration plans, transfer data locally, and verify every table without sending credentials to external servers.
Database Migration Studio separates inspection, planning, execution, and verification into explicit stages. Both the Tauri v2 desktop application and the standalone dbmigrate CLI execute the same Rust engine, storing checkpoints and logs in local SQLite.
| Component | Responsibility | Security behavior |
|---|---|---|
| Database Inspector | Reads tables, columns, keys, indexes, views, triggers, and server collation | Opens source in read-only mode; never writes to source |
| Compatibility Analyzer | Classifies findings as BLOCKER, ACTION REQUIRED, or WARNING | Flags unknown types instead of guessing conversions |
| Migration Planner | Topologically sorts tables by foreign keys and builds target DDL | Strips passwords from exported plan.json files |
| Migration Executor | Streams batches with Primary Key checkpoints for safe resume | Blocks non-empty targets by default; zero automatic DROP |
| Verification Engine | Checks 9 mandatory invariants plus SHA-256 normalized row digests | Verifies source fingerprint invariance before and after transfer |
| Route | Priority | Status | Notes |
|---|---|---|---|
| MySQL / MariaDB to PostgreSQL | P0 | Supported | Handles UNSIGNED, TINYINT(1), DATETIME, DECIMAL, JSON, ENUM, zero dates |
| PostgreSQL to PostgreSQL | P1 | Supported | Version upgrades and cloud consolidation with pgcopydb command export |
| MySQL to MySQL | P1 | Supported | Collation checks, single-transaction snapshot, PK checkpoint resume |
| SQLite to PostgreSQL | P1 | Supported | Dynamic type affinity normalization and autoincrement sequence reset |
| CSV / SQL Dump to MySQL or PostgreSQL | P2 | Experimental | DDL and INSERT fixture ingestion for offline evaluation |
| SQL Server / Oracle routes | P2 / P3 | Planned | Tracked on public roadmap; not enabled for production cutover yet |
No. Desktop and CLI users install a standalone native binary without Docker. Docker Compose is used only in CI integration tests against real MySQL, MariaDB, and PostgreSQL containers.
Passwords remain excluded from serialized plan.json files, HTML and JSON verification reports, and job logs. CLI runs accept credentials through environment variables or OS key storage.