SQL Reporting over Results Database?

[Scott]

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!

[Boyan Boev]

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

[Scott]

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

[Boyan Boev]

Hi Scott,

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

Regards,
Boyan Boev
the Telerik team

[Scott]

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

[Boyan Boev]

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