Checks on Check-In

SQLSeeker

Hi. Just wanted to ask if the Redgate products (Source Control, Prompt) allow a check of a SQL script against set rules such as; must contain a transaction, try..catch and would prevent check-in until the associated checks are passed?

Many thanks!

silverbullettruck

There isn't a RedGate product I know of that will do that. If anything could do it, it would be SQL Test, but I am not confident that you could write tSQLt that would catch a lot of those situations. It would be a "square peg/round hole" situation. There is a product made by Pragmatic Works called Pragmatic Workbench that has a tool called "Best Practices Analyzer" that I believe will do exactly what you want. It takes some configuration to get all of the best practices setup, but it is pretty flexible. There may be something else out there as well, but I am not aware of it.

SQLSeeker

Superb, thank you for the response.