[aesthetics1]

Thanks for sharing this. I have been evaluating the red gate suite of tools. Is there a particular module in their deployment suite that helps manage/automate standards as you mentioned?

Our team consists of a single DBA and around a dozen developers. We're a .NET/C# shop but we use Oracle Databases.

[davismwfl]

On the project we used red gate for we were dealing with a Microsoft shop, so SQL Server. And we used the full suite, including SQL source control which gave hooks for some of our custom scripts to run too, but most of it was doable with the tooling. The software wouldn't catch all policy violations, but what it make it quick for us to fix them when they were found. But in general we were able to automate 98% of the tasks and only deal with true outliers.

I am not sure with Oracle what is available specifically and it has been a number of years since I worked with redgates tooling, but it was quality stuff. And I remember them being super helpful when we were getting started and answering a ton of questions, so maybe reach out to them with your specifics and see what they have to say. Some things they helped us do were not obvious in their documentation or UX, so it is worth a chat with them.

[aesthetics1]

Thanks a lot for this. I'm in touch with the red gate folks now and I appreciate you sharing your experience.