How to save Load Test reports in SQL Server

Hey Guys, recently I was working on Load Test automation using VS. By default VS stores all your Load Test report in SQLExpress but I wanted to have them stored on SQL Server. I digged hard and found out that following some simple steps it can be attained. I thought of sharing the same idea with you guys so that you dont have to dig in that hard.

So here we go..

Open the VS command prompt and type

cd n:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE.

dont forget to replace n: with the drive where your Visual Studio folder resides.

Once you are into that folder you need to type

SQLCMD /S localhost -i loadtestresultsrepository.sql

“loadtestresultsrepository.sql” contains all the sql scripts that create the “LoadTest” DB and another 24 tables in your sql server.

You also need to give credentials to connect to your DBserver( which in this case is localhost), you can give it using the following syntax

SQLCMD /S localhost -U <user name> -P <password> -i loadtestresultsrepository.sql

Once done with the above steps Click “Administer Test Controllers” under the “Test” Menu.

Click the browse button(…) to select the “LoadTest” DB.

You are now ready to run your Load Test and use your SQLServer Reporting Services to generate custom report.

Happy Testing

Danish Khan

Ramp Technology