DB code review process

SVA 86 Reputation points
2024-03-29T09:11:43.4266667+00:00

Hi

We have an environment where multiple developers are working on shared Dev, Stage and Production. Can you please suggest a tool to be used that can be used when any developers want to review the Database code during the process of deploying from Dev to Production. Is there any way to notify the DBA once the DB code need to be reviewed and deployed.

SVA

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,629 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Greg Low 1,155 Reputation points Microsoft Regional Director
    2024-04-02T09:38:36.4033333+00:00

    How are you developing the database code?

    If you are using tools like SQL Server database projects, you can easily combine that with tools like Azure DevOps to manage the deployment process. And that can deploy to different stages (think environments like Test, UAT, Prod). You can add approval gates between each.

    And the schema comparison tools that come with them can show the DBA what's different each time.

    0 comments No comments