Stop Hand-Rolling SQL Server Seed Data Scripts - Use DataTongs
Deploy seed data and reference tables alongside your SQL Server schema — no hand-rolled INSERT scripts, no foreign key ordering headaches. Deploy in the right order without manually figuring out foreign key dependencies.
Your schema's in source control. Your changes deploy automatically. But what about the data? Lookup tables, seed rows, reference data — that stuff needs to ship too. In this tutorial, you'll extract reference data from AdventureWorks with DataTongs, wire it into your deployment pipeline, and watch SchemaQuench deliver it in FK-aware order. Four tables, one command, zero manual sequencing.
What you'll learn:
• How DataTongs extracts table data into source-controlled content files
• Configuring table filters so dev environments only get the rows they need
• How Enterprise DataTongs auto-wires Data Delivery properties into your table JSON
• Deploying data with SchemaQuench in automatic foreign-key order
• The difference between Enterprise content files and Community standalone MERGE scripts
Chapters:
0:00 Intro
0:05 What DataTongs Does
0:37 Demo Configuration
1:08 Run DataTongs
2:32 Run SchemaQuench
4:34 Verify The Data
5:47 Recap
Episode 3 of the Getting Started series — trilogy complete.
Previous episodes:
• SchemaTongs Getting Started (extract schema): • Get Your SQL Server Schema Into Version Co...
• SchemaQuench Getting Started (deploy schema): • Deploy SQL Server Schema Changes Without W...
This tutorial shows the Enterprise DataTongs workflow (content files + automatic Data Delivery).
Community edition users: DataTongs generates standalone MERGE scripts — see https://schemasmith.com/documentation...
Follow along with the demo repo: https://github.com/Schema-Smith/Schem...
DataTongs docs: https://schemasmith.com/documentation...
Data Delivery docs: https://schemasmith.com/documentation...
Get started free: https://schemasmith.com/documentation... Full documentation: https://schemasmith.com
#SQLServer #SeedData #DatabaseDevOps #GettingStarted
Shape. Strengthen. Succeed.