What are the benefits of SQL Test?

oi_bill

I'm already a user of SQL Prompt. I'm implementing unit testing with tsqlt but don't know enough about what SQL Test brings to the party that I can make a valid case for my boss to spend the money on it. What benefits, other than implementing SQL Cop, does it bring?  Adding a GUI interface on top of tsqlt isn't enough value to warrant the cost when you are already someone that scripts repetitive tasks.

squigley

Good Afternoon!
Thanks for your inquiry with SQL Test.

It basically acts as a frontend for managing the tests. This can involve using the GUI to help you with visualizing both your tests and the results, providing pre-written tests, and can also make it easier to integrate the tests into your automated build process.

Please let me know if you have any other questions or concerns.

Thanks!

oi_bill

How does the GUI help to integrate into the automated build process?

squigley

Good Afternoon,

Apologies, I misspoke in the last message regarding the SQL Test GUI being used for the automated build. You would just add as part of the process as mentioned here:
https://documentation.red-gate.com/sca/developing-databases/concepts/advanced-concepts/sql-unit-testing-with-sql-change-automation-projects

Let me know if you have any other questions or concerns.

Thanks!