Skip to content
SQL & Beyond

SQL & Beyond

  • home
  • featured
    • marcus-belz.de
    • Pencil’n more
    • DI²
    • GitHub: di2-starter-kit
    • my son’s web site
    • Alex Sprogis: AI Coding Starter Kit
  • imprint
  • privacy
  • contact
  • English
    • Deutsch
    • English

Cutover

Low-Downtime Migration SQL Server → PostgreSQL — Strategies for the Cutover

6. October 2026 by marcus

The question comes up reliably in the first planning round, and it rarely comes from IT: how long will the database be unavailable during the move? The answer decides whether the data is moved in one piece inside a maintenance window, whether the bulk is copied ahead of time with only the changes following until … Read more

Tags Cutover, Data Migration, PostgreSQL, SQL Server

Newsletter

Sign up

Article Series

  • Data Quality in an ETL Process
  • Data Quality Checks with SQL
  • Data Migration: SQL Server → PostgreSQL
  • AI-Assisted SQL Development
  • Structuring & Formatting SQL
  • SSIS vs. T-SQL

Categories

  • AI & Development (24)
  • Data Quality (8)
  • Database Deployment (5)
  • SQL & Databases (39)

Latest Posts

  • Data Quality: Dimensions and Error Classes — the Theory Behind the SQL Checks
    Published Jul 2, 2026 · Updated Sep 27, 2026
  • Deriving SQL Conventions with Claude Code — the Generate-Refine-Derive Loop
    Published Jun 12, 2026 · Updated Oct 20, 2026
  • The Agent Measures Where I Click — Debugging Postgres, Docker and a Swapping Server with a Coding Agent
    Published Sep 11, 2026 · Updated Oct 20, 2026
  • I Gave Claude Code 27 Rule Files Instead of One CLAUDE.md
    Published Jul 22, 2026 · Updated Oct 20, 2026
  • Agentic Coding from a User’s Perspective — Experience: The Work Doesn’t Disappear, It Shifts
    Published Sep 6, 2026 · Updated Oct 20, 2026
  • The Context Window Is Full Before the First Prompt — When Project Rules in Claude Code Become a Fixed Cost of Every Session
    Published Oct 20, 2026

Tags

AI-Assisted Development (13) AI Agents (7) Claude Code (22) Code Quality (6) Data Migration (8) Data Quality (18) Data Type (6) Developer Workflow (20) ETL Process (7) PL/pgSQL (6) PostgreSQL (19) Readability (7) SQL Server (8) T-SQL (12) TRY_CONVERT (6) Type Conversion (8)

Show all tags

© 2018–2026 Marcus Belz · Imprint · Privacy · Contact · How This Blog Is Made

All tags

AI (1) AI-Assisted Development (13) AI Agents (7) Automation (1) Backfill (1) Change Tracking (1) CI/CD (2) Claude (1) Claude Code (22) Code Quality (6) Comparison (1) Context Management (1) Conventions (3) Cutover (1) Database Deployment (5) Data Integration (1) Data Migration (8) Data Quality (18) Data Quality Dimensions (1) Data Quality Rules (4) Data Transfer (1) Data Type (6) Data Type Mapping (1) Design Pattern (5) Developer Workflow (20) Duplicates (1) Dynamic SQL (4) ELT (2) Error Classification (1) ESLint (1) ETL (1) ETL Process (7) Expand/Contract (1) Formatting (5) GitHub Actions (2) Logging (1) Maintainability (3) Metadata (1) Naming Convention (4) PL/pgSQL (6) Postgres (5) PostgreSQL (19) Project Setup (1) Project Template (1) Prompt Engineering (1) Readability (7) Referential Integrity (1) Schema Evolution (3) Schema Migration (3) Source Control (1) SQL Server (8) SSIS (5) SSIS vs. SQL (4) Stored Procedure (1) T-SQL (12) Table Design (1) Theory (1) TRY_CONVERT (6) Type Conversion (8) Validation (1) Verification (1) XML (1)