This is a migrated thread and some comments may be shown as answers.

SQL Reporting over Results Database?

5 Answers 98 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Scott
Top achievements
Rank 1
Scott asked on 18 Mar 2013, 10:19 PM
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!

5 Answers, 1 is accepted

Sort by
0
Boyan Boev
Telerik team
answered on 19 Mar 2013, 11:11 AM
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
0
Scott
Top achievements
Rank 1
answered on 19 Mar 2013, 08:31 PM
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
0
Boyan Boev
Telerik team
answered on 20 Mar 2013, 03:12 PM
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
0
Scott
Top achievements
Rank 1
answered on 20 Mar 2013, 08:24 PM
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
0
Boyan Boev
Telerik team
answered on 21 Mar 2013, 01:08 PM
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
Tags
General Discussions
Asked by
Scott
Top achievements
Rank 1
Answers by
Boyan Boev
Telerik team
Scott
Top achievements
Rank 1
Share this question
or