Looking for a DML script running tool

  • My company is still in start-up mode.  Because of this, we have a lot of holes in things like "Administrative Apps".  Right not, service tickets to fix data in the back end are completed by our engineers creating SQL scripts and editing live data.  I want to stop that practice.

    Does anyone know of any tools out there that would manage DML queries at the enterprise level?  We have some 200+ engineers, and what I am looking for is some sort of tool that would allow the engineers to submit DML: queries to be ran, but those queries go through an approval process and are then executed against the DB (eliminating the need for engineers to have write access).

    Any thoughts?

  • It sounds like you're describing Database DevOps. Basically, code goes into source control. You can run a linter through it there, or automatically later. Set up continuous integration to test the code out of source control. Then have a flow control tool to deploy to QA/Test/Staging/Pre-Prod what have you, including automated testing.

    Here's an article with the basics. There's also a link to a white paper. This is a large undertaking, just so you know.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply