Deploy SQL Server Schema Changes Without Writing Migration Scripts
Deploy schema changes to SQL Server without writing a single ALTER script -- free with SchemaSmith Community Edition.
You've got your schema in JSON files. Now what? In this tutorial, you'll fix real issues from a fresh SchemaTongs cast, make an edit to AdventureWorks, and deploy it all with SchemaQuench. No migration scripts. No figuring out drop-and-recreate order. You edit the metadata, run one command, and SchemaQuench handles the cascade automatically.
What you'll learn:
How SchemaQuench's declarative model works (desired state, not imperative scripts)
Fixing the product name after a fresh cast (product ownership safety feature)
Handling computed column dependencies in scripted objects
Widening a column that cascades through an index and three foreign keys -- one-field edit, automatic cascade
How to verify your changes with log grep and SQL spot-checks
Chapters:
0:00 Intro
0:34 What SchemaQuench does
0:52 Configuring SchemaQuench
1:43 Fixing the product name
2:39 Fixing an idempotency issue
3:43 Editing a table definition
4:31 Applying the table change
5:09 Recap and what's next
Follow along with the demo repo: https://github.com/Schema-Smith/Schem...
SchemaQuench docs: https://schemasmith.com/documentation...
Get started free: https://schemasmith.com/documentation...
Full documentation: https://schemasmith.com
This Is Part 2 of Getting Started
*Part 1:* "Get Your SQL Server Schema Into Version Control in 5 Minutes" shows how to extract your schema with SchemaTongs.
*Part 3.* "Stop Hand-Rolling SQL Server Seed Data Scripts — Use DataTongs" completes the trilogy showing how to extract reference data with DataTongs.
Next: Scale & Secure Your Deployments
• "Deploy to 50 Databases with One Click" — Use templates to deploy to multiple databases at once
• "Safe SQL Server Deployments: How product.json Prevents Wrong-Server Disasters" — Advanced safety configuration
Why Declarative?
"Declarative vs Imperative, Which Migration Strategy Is The Best?" explains the strategy behind SchemaQuench's approach.
#SQLServer #SchemaDeployment #DatabaseDevOps
Shape. Strengthen. Succeed.