Database migrations are among the most complex initiatives organizations undertake. They involve multiple teams, multiple technologies, competing priorities, operational risk, testing requirements, governance processes, and business-critical applications. Yet despite the complexity, one of the biggest challenges I repeatedly encounter during…
This is Part 2 of a series on madsql. Part 1 covered split-statements. This post covers infer-schema, recovering CREATE TABLE DDL from a SQL workload when your source schema is incomplete or missing. One of the most common situations on…
Planning, Preparation, Execution, and Validation In my previous blog post, “The Migration, Optimization, and Innovation Journey”, I discussed how modernization is not simply about moving workloads from one database platform to another. Modernization is a broader operational and strategic transformation…
Technology modernization is often viewed as a single event: Migrate the workload.Move the data.Cut over the application.Declare success. In reality, successful modernization initiatives are rarely that simple. Over the years, I’ve found that the organizations achieving the best long-term outcomes…
This is Part 1 of a series on madsql, a deterministic CLI tool for SQL dialect migration. The series covers split-statements, infer-schema, and convert in the order you’d reach for them on a real migration project. The instinct on a…