- Last Updated: [[2020-12-04]] - [[Visual Studio Load Testing]] - # Prerequisites - A remote/local Microsoft SQL Server that is compatible with the version that comes with the Visual Studio installation. For Visual Studio Enterprise 2015, the SQL Server version was 12.00.2000, which is SQL Server 2014. See this link for other versions: https://support.microsoft.com/en-us/kb/321185 - Permissions to create a database (and/or tables) on the relevant server. - # Changing the store - Click on Load Test from the menu > Manage Test Controllers > Click the "..." to change the results store. - Change the Visual Studio settings to save results to the new database. - Enter the server name. Ex: `n635` or `10.16.30.69`. - Either authenticate via Windows authentication or enter the details required for SQL Server Authentication. - Wait for the database names to populate. - Select the relevant database. - Test Connection. - Click OK. - Create the schema of a load test repository in the other database. - Navigate to `C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE` and copy the loadtestrepository.sql file. - In Visual Studio, click on View > Server Explorer. - Right click on Data Connections and click Add Connection. - Enter the server name, test the connection, and click OK. - Right click on the database and click New Query. - Paste the SQL query from loadtestrepository.sql into the Query Editor and click the green > triangle to execute it. You will need the appropriate permissions to create a new database (or, if you edit that part out, the new tables and procedures). - Set the connection string for the new repository - From Visual Studio, Click Tools > Options > Database Tools > Data Connections. - Type the name of the repository in the field SQL Server Instance Name. -