I am building a database for internal company use. I have a SQL project in VS that contains all the structure. This is in source control. Now, there are tables in this database that will have static/controlled data. Data that should exist, exactly the same, in every instance of the database, production or otherwise. Currently, I am accomplishing this through a Post-Deployment script which runs a series of MERGE statements. This script is also checked into source control. My question is this: has anyone done it in a way they might consider better? It feels a little weird checking “data” into source control, but then again, it can be seen as versioned. In case it matters, we are using SQL Server 2019, on-prem.

I am trying to debug Microsoft SQL stored procedure from visual studio 2022. When i step into the code, I see the attached image. Actual stored procedure is not getting opened. Is there any solution for this? SQL server is in same PC.

I am looking for a way to automatize multiple time this Visual Studio feature