Share via

DB code review process

SVA 116 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.
13,827 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Greg Low 1,760 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.