Wednesday 30 November 2011

MS SQL Script Runner

Currently I'm making a script runner using C# WPF in visual studio 2010. It can run many MS-SQL scripts with the click of one button. This is a progress so far screen shot...



Features are :
Drag And Drop script files
Run a directory of script files
Sql Script out put messages during execution
Script passed or failed that are colored green and red (yellow for running)
Stop on error option
Open script on error option
Run report with time taken for each script
Total duration time
Test DB connection
Asynchronus
.Net 4 & tested with SQL 2008
Single exe file

More to come.....



Edit:

This is now complete. If anyone is interested just ask for the exe file. One of the biggest advantages with our script runner is that faster than the DB client library. We are using SMO library for execution, we managed to compile it for .net4. We have a large statement timeout but can abort at any time during the execution.

No comments:

Post a Comment