To configure Visual studio load test Database manually perform following steps:
- Open a Visual Studio Command prompt. Type the following text: On a 32-bit version of Windows type: cd “c:\Program Files\Microsoft Visual Studio 12.0\Common7\IDE” -or- On a 64-bit version of Windows type: cd “c:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE”
- In that folder, type the following text:
- SQL Express: SQLCMD /S localhost\sqlexpress /i loadtestresultsrepository.sql
- SQL: You can install the database to any existing SQL server. For example, if you had a SQL server named Server1 you would use the following command: SQLCMD /S Server1 -i loadtestresultsrepository.sql
Caution The parameters are case sensitive. You must type uppercase S and lowercase i. SQLCMD /S pintu-home -i loadtestresultsrepository.sql
You might also need to specify a user name and password so that you can connect to Server. If so, you would use the following command: SQLCMD /S Server1 -U -P -i loadtestresultsrepository.sql Caution: The parameters are case sensitive.
- On the Load Test toolbar, choose Manage Test Controllers. The Manage Test Controllers dialog box is displayed.
- In the Load Test Results Connection String, click the browse button (…) to display the Connection Properties dialog box. Note:If you change the connection string for a controller, then you must select the controller.
- In Server Name, type localhost\sqlexpress or the name of the server that you used in step 2 such as Server1.
- Under Log on to the server, choose Use Windows Authentication.
- Under Connect to a database, choose Select or enter a database name. Select LoadTest from the drop-down list box.
- Choose OK.
- Choose Close in the Administer Test Controller dialog box