How can we improve SQL Test?

Test Results Output to File or Table

Output to the Test window can be fine, depending on the situation. However, an output from a full test run to a text file or to a table in a database so that you know, and can compare, one test run to another, is absolutely necessary. As you start expanding to enterprise level of testing, you need to be able to search and sift through the test results. Having them in a window that you have to copy and paste from is not automation.

14 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Grant FritcheyGrant Fritchey shared this idea  ·   ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Steve HallSteve Hall commented  · 

        Running the SQLCop tests and only seeing the last test result within the TestResult table is also part of this issue.
        All results from a class should be available.

      • David AtkinsonDavid Atkinson commented  · 

        I know it's not a perfect solution, but if you run your tests from a CI tool like TeamCity, the test results are automatically saved.

      Feedback and Knowledge Base