How can we help you today? How can we help you today?

What are the benefits of SQL Test?

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.
oi_bill
0

Comments

3 comments

Sort by
  • 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!
    squigley
    0
  • oi_bill
    How does the GUI help to integrate into the automated build process?
    oi_bill
    0
  • 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!

    squigley
    0

Add comment

Please sign in to leave a comment.