SQL Load Test – Generate Visual Studio unit/load tests from a SQL Server SQL Trace

CodeProject - SQL Load Test

“Project Description

This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed to be used in a Visual Studio Load Test. The code generated is easily modifiable so that data variation can be introduced for the purpose of doing performance testing.

The tool generates code for both Visual Studio 2005 and Visual Studio 2008. The source code is a Visual Studio 2005 project.

The tool is still in pre-release stage of development.

…

… You start with using the client application to generate a trace of the SQL statements which typically represent a usage scenario. You can then turn the trace into equivalent ADO.NET code program that can be used in a load test.

…

Tool Description

The tool generates a Visual Studio 2005/2008 Unit Test from a SQL Server Profiler trace. It extracts all the SQL statements and stored procedure calls from the trace and turns them into a single Visual Studio Unit Test, which can then be configured as a Visual Studio Load Test. The tool does not interact with the database itself when it analyzes the trace and generates the test code. It can therefore be used in “offline” scenarios.

…”

Interesting… My team was just chatting about about unit testing databases and I was also starting to think about load testing the database.

BTW, source is included in the released…

(via Willy-Peter Schaub's Cave of Chamomile Simplicity - SQL Load Test Tool ... the VSTS rangers release another great codeplex project!)