I have always been the big admirer of automation in SQL Server. Today, I found a new tool quick way of executing bunch of script files.
Script executor is a small, free SQL tool that allows you to run multiple T-SQL scripts at once against a SQL Server database. You can choose to run a single script file or a group of files identified by a pattern. You can select different script execution modes, run it interactively via the user interface or in batches via the command line options. And mainly it supports SQL Server 2000 and above versions.
- Execute multiple scripts at once
- Support different transactional execution – Running All Script in one Transaction or Running Each script in one transaction
- Command line options for batch execution – helps to execute the script through command prompt