Skip to content
dbtuneup
Get started
Service 03

Database migration

Single-engine upgrades or full cross-engine migrations using pgloader, AWS DMS, or custom ETL pipelines — with a verified cutover.

See pricing Talk to an engineer

At a glance

Output
Migrated DB, runbook, rollback
Duration
3–10 business days
Starts at
$98.00
Choose a plan Ask a question
30-day money-back guarantee
The problem

Migrations fail in the boring places — a TIMESTAMP that's actually a string, a FK that nobody documented, a trigger that nobody knew about. Without a dry-run on staging, the cutover is a coin flip.

Our approach

We always dry-run on staging first, with production-shaped data. Type mappings are explicit. FKs are validated. The cutover plan has a written go / no-go gate before we touch live traffic.

What's included

Everything in scope, named.

Concrete deliverables — no vague promises about "best practices".

01

Schema dump, sanitised replay on staging

02

Cross-engine type & FK mapping (MySQL ↔ Postgres, SQL → Mongo)

03

Logical replication / dual-write cutover under 5 minutes

04

Backup + rollback scripts, post-migration smoke tests

How it unfolds

A clear runbook, not a black box.

  1. 01

    Dump & sanitise

    Schema and a sanitised data sample land on staging. PII is masked before it leaves your network.

  2. 02

    Map types

    Cross-engine type and constraint mapping — every field documented, no implicit conversions.

  3. 03

    Dry-run

    Full migration on staging. We replay traffic and verify row counts, FKs, and triggers match.

  4. 04

    Cutover

    Logical replication or dual-write window. Typical downtime under 5 minutes. Rollback is tested before we start.

  5. 05

    Verify

    Post-cutover smoke tests + 24h monitoring window included.

Tools we reach for

Battle-tested, not shiny.

The tools we trust on real production workloads — that's what we'll be using on yours.

pgloader AWS DMS pg_dump / mysqldump logical replication slots Debezium

Best for

  • ✓ MySQL → PostgreSQL or PostgreSQL → MySQL
  • ✓ Hosted → self-managed (or vice versa)
  • ✓ Major-version upgrades with non-trivial schema drift
  • ✓ SQL → MongoDB or MongoDB → PostgreSQL

Not the right fit when

  • ✕ No-downtime sub-second cutovers on petabyte-class workloads — those need a longer engagement
Plans

Pick a plan that includes this service.

All plans ship with a 30-day money-back guarantee.

Quick Audit

Spot the bottleneck fast

$9.99 one-time
Choose plan
Popular

Index Optimization

Faster reads, leaner writes

$13.00 one-time
Choose plan

Migration Standard

Move it, cleanly

$98.00 one-time
Choose plan
Compare all plans →
Related services

Often paired with

All services →
Service 01

Performance audit

A focused read of your slow-query log, EXPLAIN plans, and missing indexes — turned into a punch list of the highest-impact fixes.

Read more
Service 02

Index & query optimization

We rebuild your index strategy on a staging copy, rewrite the worst offenders, and verify with before/after benchmarks.

Read more
Service 04

Schema review & normalization

A senior pair-of-eyes on your schema — flagging accidental N+1 designs, denormalisation that hurt you, and modelling that won't scale.

Read more

Ready to start your database migration?

Pick a plan that fits, or send us a paragraph about what's slow — we'll come back within an hour.

See pricing Talk to us