How to: Add a Database Data Source to a Web Performance Test
Before you can add data binding to a Web request, you must add a data source to the Web performance test. After you add a data source to a Web performance test, you can bind a Web request to the data. For more information, see How to: Add Data Binding to a Web Request. After you add data binding to a Web request, you must configure the test run to access one or more rows of data. For more information, see How to: Configure Web Performance Tests to Run Once Per Data Row Using Test Settings.
Requirements
- Visual Studio Ultimate
To add the data source to the Web performance test
In the Web Performance Test Editor, right-click the top node of the Web performance test and then choose Add Data Source.
The New Test Data Source Wizard appears.
In the Data source name box type a name for your data source.
In the Data source type list choose Database.
Choose Next.
Select an existing connection, or follow these steps:
Choose New Connection.
The Choose Data Source dialog box appears.
In the Data source list, choose the appropriate source for your database.
(Optional) In the Data provider list, choose the appropriate provider for your database.
(Optional) Clear the Always use this selection check box.
Choose Continue.
The Connection Properties dialog box appears.
Enter the information to connect to your database.
(Optional) Choose the Test Connection button to verify your connection to the database.
Choose OK to close the Connection Properties dialog box.
The connection string to access the database is entered in the wizard.
Choose Next.
Under Choose from the available tables for this data source, select the check box next to each table that you want to include in the data source.
Choose Finish.
If your database is a file, for example a Microsoft Access database, a dialog box appears that asks you if you want to add the file to your current project. You can use the following information to help you decide:
Response
Result
Advantage
Yes
The file is copied to the project.
When the project is deployed, there is no extra work that is required.
No
The file is not copied to the project. When the project is deployed, you might have to update the path of the file.
Some data files can be very large, and should be maintained separate from the project. Some data files must be shared among several members of a team, and should be maintained in a central location that all members can access.
Choose Yes or No.
A Data Sources node is added to the Web performance test, and the database and tables appear in the hierarchy.
On the Filemenu choose Save to save the Web performance test.
See Also
Tasks
Walkthrough: Adding Data Binding to a Web Performance Test
How to: Add a CSV File Data Source to a Web Performance Test
How to: Add an XML File Data Source to a Web Performance Test