Get Your SQL Server Schema Into Version Control in 5 Minutes
Extract your SQL Server database schema into files you can commit to Git — free with SchemaSmith Community Edition.
No more "what's actually in production?" guesswork. In this tutorial, you'll run SchemaTongs against a live SQL Server database and walk away with a clean folder of metadata files that belong in Git. It's the first step to treating your schema like code — and it takes about five minutes.
What you'll learn:
What SchemaTongs does and why schema extraction matters
How to configure AppSettings.json and run the tool
What the output looks like and how it maps to your database objects
Where these files fit into a version control workflow
Chapters:
0:00 Intro
0:29 The Problem
1:00 What SchemaTongs Does
1:11 Demo: Setup
1:50 Demo: Running SchemaTongs
2:03 Demo: Understanding the Output
3:38 Recap
3:50 What's Next
Follow along with the demo repo: https://github.com/Schema-Smith/Schem...
SchemaTongs docs: https://schemasmith.com/documentation...
Get started free: https://schemasmith.com/documentation...
Full documentation: https://schemasmith.com
This Is Part 1 of Getting Started
*Part 2:* "Deploy SQL Server Schema Changes Without Writing Migration Scripts" shows how to deploy your extracted schema with SchemaQuench.
*Part 3.* "Stop Hand-Rolling SQL Server Seed Data Scripts — Use DataTongs" completes the trilogy showing how to extract reference data with DataTongs.
What Comes After
Once you've extracted and deployed, explore:
• "Deploy to 50 Databases with One Click" — Scaling to multiple databases with templates
• "Safe SQL Server Deployments: How product.json Prevents Wrong-Server Disasters" — Advanced safety features
Why Declarative?
New to this approach? "Declarative vs Imperative, Which Migration Strategy Is The Best?" explains the philosophy.
#SQLServer #SchemaVersionControl #DatabaseDevOps
Shape. Strengthen. Succeed.
Tags
SQL Server version control, database schema version control, schema version control, SQL Server schema management, database DevOps, schema as code, database schema extraction, SQL Server metadata, SchemaTongs tutorial, SchemaTongs, SchemaSmith, SchemaSmith Community, database schema to git, SQL Server schema to files, getting started SchemaSmith
Hashtags
#SQLServer #SchemaVersionControl #DatabaseDevOps