How to run stored procedure in web test project and take data.

[Krish]

Hi,
 
I need solutions for following queries.

01. How to run stored procedure in web test project and take data. Scenario is as follows.
      ** Through the automation script I need to run the stored procedure and take some data from DB.
 Output of that query (result of that stored procedure) must write into the excel or xml file. Please provide your guide lines to successfully execute above scenaio.

02. I could successfully created Test list and add my test list to the Result sections when I was executing automation script in web test project. But I could not create Test list when I was executing automation script in Load testing project. Simply how to create Test List in Load testing project.


Note: - I am using Test studio 2012.2 and standalone app(web test project).

Thanks..

[Byron]

Hello Krishan,

Thank you for your interest in TestStudio.

Although TestStudio is not designed to directly handle writing your output back to an Excel/xml file through generic steps, the functionality can be achieved through a coded step. This example from our online documentation regarding Coded Steps will demonstrate how to Write Into the Data Source.

As far as creating a Test List of Load Tests, this is a current Feature Request  in our Public Issue Tracker and would make its way into a future build pending enough interest from our voting system. Place your vote through this link to the feature request.

Let me know whether you have any followup questions.

All the best,
Byron
the Telerik team

[Krish]

Hi Byron,,

  Query no 01:-Can you explain how to run the stored procedure in stastandalone app..??? basically I need to RUN stored procedure and take data from DB(MS SQL). So please give ur guide lines to run the stored procedure in the automation script..

  Query no 02:- Is it possible to run the stored procedure in the Load testing project..?? basically how to edit the recorded script in the load testing project and execute the stored procedure..??

Thanks..

[Byron]

Hello Krish,

Query no 01:- You can run SQL queries as part of a coded step. 

Query no 02:- A load test project will run each step in a test project, including coded steps, and capture the traffic this test generates. Then it will reproduce that traffic for each virtual user in the load test. You can data drive the load test to customize the traffic generated based on the contents of a SQL database table. However, there is not currently a feature to execute a coded step for each virtual user.

Greetings,
Byron
the Telerik team