Tuesday, October 19, 2010

Create a load test result database

One of the nice features of Visual Studio 2010 Ultimate is the load testing. This allows you to schedule a set of automated test scenario’s using multiple criteria like number of users, distribution, network latency,… Results of these load tests are stored in a SQL database.

Before you can save the load test results to the database, a database schema must be created,

To create the load test database:
  1. Open a Visual Studio Command prompt. Browse to the following location: cd c:\Program Files\Microsoft Visual Studio 10\Common7\IDE
  2. In that folder, type the following command:

    SQLCMD /S localhost\sqlexpress /i loadtestresultsrepository.sql

Remark:The parameters are case sensitive. You must type uppercase S and lowercase i.

No comments: