Why use Visual Studio SSDT?
1) Speeds development. 2) Reduces coding errors. Visual Studio with SQL Server Data Tools (SSDT) transforms the SQL Server Database development process from single-object creation and editing to solution-based database development, maintenance, and deployment. Solutions based paradigm brings the same features and tools available with object oriented languages: version control, build verification, unit testing, CI/CD,…
Foundations
Overview Tips
Overview, tips, and notes for the database development using SSDT.
Database Project Properties
Setting initial Project Settings and Debug Properties.
Visual Studio Solution for SSDT
Create an empty solution then add a SQL Server Database Project.
Getting Started
Get started using Visual Studio to develop and publish SQL Databases.
Beginner
Publishing
Deploy or Publish database to multiple databases… and create the script that does it.
Verify SQL Objects
Identify missing database objects and other errors.
Add Data via Scripts
Populate the database using pre and post deployment scripts.
What about Existing Databases?
Its easy: Existing databases can be importing into new SSDT project.
Create Database Objects
Finally, we can create some database objects: schemas, tables, and views!
Rogge Heflin 