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.
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.
SQL Server to Oracle Migration: A Schema-Level Guide
Migrating SQL Server schemas to Oracle: data type mapping, IDENTITY to sequences, identifier case rules, the empty-string trap, and generating safe migration DDL.
Product
Run One SQL Query Across Multiple Database Servers
How the FoxSchema SQL Editor runs the same query against several database servers at once, with per-connection variables, safe mode, and side-by-side results.
Database Guides
Oracle to PostgreSQL Migration: A Schema-Level Guide
A practical guide to migrating Oracle schemas to PostgreSQL: data type mapping, sequences and identity columns, PL/SQL objects, and generating safe migration SQL.
