Add support for debugging

Bart ReadBart Read Posts: 997 Silver 1
edited October 14, 2016 11:42AM in SQL Test
Hi there,


SQL Server Management Studio supports debugging so it would be *really*, *incredibly* handy to be able to take advantage of this in SQL Test. Diagnosing errors in SQL (or any other code) is so much easier when you can step through it with a debugger. Any chance you could add a "Debug Test(s)" option, again, like R#'s test runner in Visual Studio, please?


Thanks,
Bart Read
Principal Consultant
bartread.com Ltd

Comments

  • Hi Bart,

    There are a couple open issues (design changes - SQT-146 and SQT-148) that are regarding this exact thing. I have added a reference to your request in each though as of now one is marked as Future and the other is in the Backlog. I would also vote on this Uservoice which appears to be similar too.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Bart ReadBart Read Posts: 997 Silver 1
    edited May 9, 2017 10:11AM
    Thanks Alex,

    There is also a workaround, in that you can just open a query with
    EXEC [ClassName].[TestSprocName]
    

    and set a breakpoint on that but it would be great to have something a bit more seamless.


    Cheers,
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Hi Bart,

    Thanks for sharing that!

    I've updated the internal issue as well so it can be passed on to others until support has been implemented into the tool.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.