-
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.