How to version control a database using GitHub and SQL Source Control

This article explains some simple steps to create a GitHub database repository and then version control your SQL Server database, for team development work, using SQL Source Control. Read more

Generating test data with localized addresses using SQL Data Generator

With basic grasp of regex expressions, a tool like SQL Data Generator can generate test data with addresses that are realistic for your part of the world. Read more

Comparing SQL Server Databases using DacPacs and SQL Compare

How to compare SQL databases using DACPACs, script out differences and then run a database deployment task to synchronize the schema of the target database. Read more

SQL Deployment Automation using SQL Compare Command Line

SQL Compare provides a command line interface (CLI) for running database schema comparisons and generating a deployment script, as part of a scripted process. I'll demonstrate how to do this with a 1-click process, using a batch (.bat) file. Read more

Versioning an existing database using SQL Source Control

How to bring an existing database under Git version control. Read more

How to create a directory of object-level scripts using SQL Compare

How to create a directory of object-level scripts from an existing database using SQL Compare GUI or command line. Read more

Using SQL Compare with In-Memory OLTP tables

SQL Compare can help you compare two databases that have In-Memory objects, the tables, their indexes and any natively-compiled procedures, and generate the appropriate scripts. Read more

Using SQL Compare with Row Level Security

As you test your row-level security in various environments, you can use SQL Compare to script out and deploy those changes to other databases. Read more

Using SQL Compare with Dynamic Data Masking

SQL Compare works with dynamic data masking, detecting the differences in masks across tables and generating the T-SQL you need to deploy your masking configuration to other databases. Read more

Source controlling your database permissions

How to use a combination of database roles, along with rules, filters and post deployment scripts in SQL Source Control, to add the required users to the correct role, for each database. Read more

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Product articles SQL Toolbelt