Visual Studio SQL Server Database Project

  • Visual Studio SQL Server Database Project – Lookup Data

    Lookup tables are defined and populated early in development to support other development efforts. Functionality at other layers in the solution can be driven off lookup values. Deploying lookup data and keeping it consistent between environments is critical to reducing issues.

  • Visual Studio SQL Server Database Project – The Basics

    Visual Studio has long had a solution to manage a database’s schema, SQL Server Database Projects. Initially a part of the SQL Server Data Tools add-on, it’s now a feature in the Visual Studio installer for 2022 (and since 2019). Building the projects results in a DACPAC being generated. This is consumed by sqlpackage.exe to deploy schema changes.

%d bloggers like this: