SSDT Publishing 27 January 202327 January 2023 FIRST: We're using SSDTDatabase Project and we introduced an error in an earlier post; resolve this error, delete or use the correct column name in the view, to continue. Typically,…
SSDT Verify SQL Objects 21 January 202321 January 2023 SSDT identifies missing database objects. Yes! In a database with many objects, identifying views, stored procedures, and functions that point to a non-existent column, table, or another object throws an…
SSDT Add Data via Scripts 13 January 202313 January 2023 SSDT has can execute two types of scripts: Deployment and Build. This post focuses on Deployment scripts that run on the target database before and after deploying or publishing the…
SSDT What about Existing Databases? 8 January 202313 January 2023 Its easy: Import an existing database into a new SSDT project. We'll use AdventureWorks2017, which can be downloaded from Microsoft, or any database where you can read the Data Definition…
SSDT Create Database Objects 6 January 202313 January 2023 Finally! The exciting and useful part of SSDT - creating the objects in the project and publishing them to the database. This short example shows how SSDT shifts developers' focus…
Rogge Heflin 