SchemaSmith for SQL Server

Extract, version, and deploy your SQL Server schemas from source control. No migration scripts. Just JSON.

Getting Started

The Tools

Three CLI tools cover the schema lifecycle on SQL Server.

SchemaTongs

Extract a live SQL Server schema into versioned JSON table definitions and SQL object scripts.

Documentation Walkthrough

SchemaQuench

Deploy schema packages to SQL Server targets with dependency ordering and idempotent scripts.

Documentation Walkthrough

DataTongs

Generate MERGE scripts for reference and seed data that deploy alongside schema changes.

Documentation Walkthrough

Explore

Start with the fundamentals, then go deeper into the SchemaSmith model.

Getting Started

Install the tools and run your first package.

Daily Workflows

Add tables, write procedures, extract drift, bootstrap environments.

Schema Packages

Structure of the artifacts SchemaSmith deploys.

Configuration

Settings, connection strings, and env vars.