MySQL to ClickHouse Migration: A Schema-Level Guide
How MySQL and ClickHouse schemas differ: engine families, no indexes/FKs/triggers, Nullable() typing, and what to check before migrating.
Db2 to PostgreSQL Migration: A Schema-Level Guide
How Db2 and PostgreSQL schemas differ — identity columns, tablespaces, naming, and types — plus a practical sequence for migrating safely.
Azure SQL vs SQL Server: Schema Differences You Need to Know
Azure SQL Database and SQL Server share T-SQL syntax but diverge on collation, cross-database queries, instance-level objects, and tier limits. Here's what breaks.
MariaDB to PostgreSQL Migration: A Schema-Level Guide
How MariaDB and PostgreSQL schemas diverge on sequences, types, and casing, and how to generate a safe migration script instead of hand-translating DDL.
Tutorials
How to Keep Staging and Production Databases in Sync
Practical ways to keep staging and production database schemas in sync and stop "works on staging" bugs before they ship.
IBM Db2 in n8n: A Docker-Distributed SQL Builder Node
n8n-nodes-db2-sql-builder brings IBM Db2 into n8n workflows via a Docker image with the native driver already built in, powered by FoxSchema's catalog engine.
FoxSchema SQL Builder for n8n: A Multi-Dialect Database Node
n8n-nodes-fox-schema-sql-builder is a community node powered by FoxSchema's catalog engine, covering PostgreSQL, MySQL, MariaDB, SQL Server, and Oracle inside n8n workflows.
SQL Editor Code Cells: Mixing JavaScript with SQL to Clean Migration Data
How FoxSchema's SQL Editor code cells (-- @js / -- @node) let you clean and reshape migration data with lodash and date-fns, right next to the query that produced it.
The Expand/Contract Pattern for Safe Schema Migrations
How the expand/contract (parallel change) pattern splits risky schema changes into safe phases, with a worked example and how to generate the SQL for each step.
Sequences, Identity Columns, and Auto-Increment: How They Differ Across Databases
How auto-increment, identity columns, and sequences differ across MySQL, PostgreSQL, SQL Server, Oracle, and Db2 — and where cross-dialect migrations break.
