Migrate a Continuously Used Database

Quick Overview

Design a migration from Microsoft SQL Server to PostgreSQL while a third-party read-only service runs continuously and one internal client owns writes; cover replication or dual-write, compatibility, verification, backups, maintenance, and cutover.

Migrate a Continuously Used Database

Company: Hadrian

Role: Software Engineer

Category: System Design

Difficulty: hard

Interview Round: Onsite

Overview: Design a migration from Microsoft SQL Server to PostgreSQL while a third-party read-only service runs continuously and one internal client owns writes; cover replication or dual-write, compatibility, verification, backups, maintenance, and cutover.

Hadrian logo
Hadrian
May 17, 2026
hardSoftware EngineerOnsiteSystem Design
2
0
Loading...