Category: Visual Studio SQL Server Project
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 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…