Click any tag below to further narrow down your results
Links
sqldef is a command line interface tool that compares two SQL schemas and generates the necessary DDLs for managing database migrations. It supports multiple databases, including MySQL, PostgreSQL, and SQL Server. You can see how it works in an online demo using WebAssembly.
This article explains the expand and contract pattern used for updating database schemas without downtime. It outlines the step-by-step process of introducing new structures, migrating data, and ensuring system integrity throughout the transition. The approach allows for safe rollbacks if issues arise during the migration.