Setup Wizard Architecture — Endrias Bridge

Wizard Steps (Left Sidebar Navigation)

Step 1 👋 Welcome License key validation, version display, EULA acceptance Required first

Step 2 🔌 Metadata Source Source DB engine selection, connection string, test connection Connection test

Step 3 ⚙️ User Settings Batch size, thread count, timeout, CDC/CT toggle, error policy

Step 4 🧩 Plugins Engine-pair plugin selection, target engine config, type-map overrides

Step 5 🗄️ DB Migration Opens DB Migration Assistant in a separate independent window (13 tabs) Launches assistant

Step 6 🔔 Alerts Email/Slack thresholds, CloudWatch alarm wiring, failure escalation rules

Step 7 📋 Review Summary of all config choices; pre-flight validation checks

Step 8 ▶️ Run Execute migration, real-time progress log, row/error counters

Step 5 — DB Migration Assistant (Independent Window)

📊 Health

Live connection health panel. Shows source/target ping latency, replication lag, active job count, and last sync timestamp. Auto-refreshes every 30 s.

📁 Projects

Named migration projects. Each project stores source/target connection, table selection, column mapping overrides, and run history. Create, duplicate, import, or export JSON.

🔍 Assessment

Pre-migration compatibility scan. Flags unsupported data types, missing indexes, circular FKs, computed columns, temporal tables, and estimated row counts. Read-only results panel (selectable + copy-enabled).

🚀 Migration

Full-load and live-sync execution. Start/pause/stop controls. Real-time row counter, elapsed time, throughput (rows/sec), and ETA. Two sub-tabs for live monitoring.

Migration Log SQL Script

⚙️ Jobs

Multi-target job scheduler. One source → many targets simultaneously. Per-job Override Target config, schedule (cron or one-shot), per-job log viewer (copy-enabled). Status: Pending / Running / Done / Failed.

🏗️ Schema Objects

Browse and generate DDL for tables, views, stored procedures, functions, and triggers. Object definition panel is read-only but fully selectable for copy-paste.

👤 Users & Logins

Source login enumeration, orphaned user detection, and DDL generation for re-creating logins on the target. SID re-mapping for SQL Server → RDS paths. DDL panel is copy-enabled.

⚖️ Comparison

Row count and checksum comparison between source and target tables. Highlights divergence. Export diff report to CSV. Used as post-migration validation step.

🔧 Tools

Ad-hoc utilities: run arbitrary T-SQL on source or target, bulk table truncate with FK disable, index rebuild/reorganize, statistics update, and temp table cleanup.

🔁 Replication

Live replication control panel. Choose CDC Stream (SQL Server / MySQL binlog / MongoDB Change Streams) or CT Sync (Azure SQL / lightweight). Three sub-tabs for monitoring.

Table Status CDC Events Sync History

🖥️ Replicas

Target replica management. Configure and monitor each cloud target independently. Auto-Failover tab orchestrates switchover with health checks.

AWS RDS Azure SQL DB Azure SQL MI Google Cloud SQL Auto Failover

☁️ Export & Cloud

BACPAC export, S3/Blob upload, and large-table seeding (≥ 0.5 TB). Configure IAM role or SAS token, set bucket/container, and schedule incremental exports.

🚨 Error Log

Unified error log for all migration activity. Severity filter (Info / Warn / Error), timestamp search, and full copy-paste support. Persisted to disk between sessions.

End-to-End Data Flow

Wizard Setup

Migration Execution

Live Sync

Validation

Error Handling

🔑 License Check

Step 1 — validates trial/commercial key before any further config

🔌 Source Connection

Step 2 — engine type, host, port, credentials; ping test required

⚙️ Run Config

Step 3+4 — batch size, threads, CDC/CT mode, plugin type map

🎯 Target Config

Plugin step — target engine, host, credentials, database name

⬇ Open DB Migration Assistant (independent window)

🔍 Assessment

Type compat scan, FK graph, row estimates, unsupported feature flags

🏗️ Schema Gen

DDL generated from source; CREATE TABLE / INDEX / FK scripts

👤 User DDL

Login enumeration → re-create scripts; orphaned user detection

🗂️ Project Save

Config snapshot saved; reusable for repeat runs or jobs

⬇ Full Load

📤 Full Load Batch

Parallel readers; configurable batch size; FK disable → load → re-enable sequence

⚙️ Jobs Engine

Multi-target fan-out; per-job Override Target; cron scheduling

🔁 Live Sync

CDC Stream or CT Sync; LSN/change-version anchor; delta apply loop

☁️ BACPAC / S3

Large-table seeding path; S3/Blob upload; IAM/SAS auth

⬇ Post-Migration

⚖️ Row Comparison

Source vs target counts; checksum diff; export divergence CSV

🖥️ Replica Health

Cloud replica status; lag metrics; Auto Failover readiness check

🚨 Error Log

All errors persisted; severity filter; copy-paste enabled for triage

🔔 Alerts Fire

Step 6 rules → email/Slack on failure, lag breach, or row divergence

Key Behavioral Notes

🪟 Independent Window

DB Migration Assistant opens as a separate Toplevel window. It does NOT call grab_set() — the Setup Wizard remains fully usable while migration runs (Change 148).

📋 Copy-Paste Enabled

All read-only text panels (Assessment issues, Schema DDL, User DDL, Failover log, per-job logs) use make_readonly() — state stays normal, mouse selection and Ctrl+C work. Right-click → Copy menu available (Change 149).

🔒 Least Privilege

Source credentials are never stored in plain text. Connection strings are held in memory only for the session. User DDL generation does not require sysadmin — only VIEW DEFINITION + VIEW SERVER STATE.