Add support for debugging

Bart Read

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,

Alex B

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

Bart Read

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,

Alex B

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