Automate SQL Server Database Migrations-For Free

Most Table Changes Require No Scripting

Widening a column requires any check constraint, index or foreign key containing that column to be dropped before it can be modified. Then you have to put all of that back on.

SchemaQuench can handle all of that for you. You widen the column in the table's json, SchemaQuench handles the dependencies.

Schema As Code

True state-based database migrations-your metadata repository defines the exact end state of your server at each release.

This means your SQL Server schema is always in sync with your source control. You gain full traceability, the ability to diff per-object changes between builds, and gain a clear history of what changed, when and why.

Easily Extract Your Schema

Use SchemaTongs to connect to a SQL Server database and it will extract your metadata representing the current state of that database - tables, procedures, views, etc.

This metadata becomes the raw material that feeds into the SchemaSmith toolchain for shaping and deploying your desired state across environments.

Database Templates

A template is a metadata representation of a database. Conceptually, in object-oriented terms, a template is a class and a database is an instance.

By defining a template, you are precisely defining what every database of that type should look like. This enables true state-based deployment.

Run Once Deployments

By defining your product entry point and the order your database templates should be updated, you can define once and deploy everywhere-automating multiple database updates with a single run of SchemaQuench.

CI/CD Friendly

Your metadata repository is all that SchemaQuench requires to apply updates. True XCOPY deployment and a commandline run of SchemaQuench makes automation a breeze.