SQL Reporting over Results Database?

6 posts, 0 answers
  1. Scott
    Scott avatar
    4 posts
    Member since:
    Dec 2012

    Posted 18 Mar 2013 Link to this post

    Hi,

    Just a quick query, I've currently been investigating setting up a Scheduling Server and publishing results to it via the ArtOfTest.Runner.exe commandline.
    I was wondering with the information that is published to this database, is it intended that these tables could be reported over using SQL Reporting (e.g. SSRS) or are they primarily just for Test Studio's use?

    I saw there was a help page around reporting over the load testing database, so that got me thinking that maybe we could report over the execution test results database as well :)

    Thanks!
  2. Boyan Boev
    Admin
    Boyan Boev avatar
    1072 posts

    Posted 19 Mar 2013 Link to this post

    Hello Scott,

    TestStudioReportingDB is a regular database like any other (see the attached screen shot).

    You can manage it in any way you want.

    Regards,
    Boyan Boev
    the Telerik team
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
  3. Scott
    Scott avatar
    4 posts
    Member since:
    Dec 2012

    Posted 19 Mar 2013 Link to this post

    Hi Boyan,

    In your attached screenshot that looks like the load testing results db? I was meaning the database that gets created when you configure the scheduling server and has the test list run results published to it. (screenshot of tables attached)

    Cheers,
    Scott
  4. Boyan Boev
    Admin
    Boyan Boev avatar
    1072 posts

    Posted 20 Mar 2013 Link to this post

    Hi Scott,

    It is one and the same database (see the screen shot). 

    Regards,
    Boyan Boev
    the Telerik team
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
  5. Scott
    Scott avatar
    4 posts
    Member since:
    Dec 2012

    Posted 20 Mar 2013 Link to this post

    Ah right, I see, I didn't realise they were all in the same database :) We're not currently using the load testing side so that would be why I didn't see the extra tables

    It looks like only the load testing result tables have relationships between them, the tables ending with _d_b (where the test list results seem to be published) don't seem to be linked so it might not be as easy to report over those ones
  6. Boyan Boev
    Admin
    Boyan Boev avatar
    1072 posts

    Posted 21 Mar 2013 Link to this post

    Hi Scott,

    Yes, unfortunately this is done by design.

    Note that manually editing the DB is at your own risk.

    All the best,
    Boyan Boev
    the Telerik team
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
Back to Top