No more! You can now use Script Executor to take care of this job for you. One time only, you will go through a simple, and may I suggest fun, process of organizing your scripts into virtual containers and your databases into groups; then, map those script containers to the database groups; set an order of precedence if you need to and voila you have a package that you can now execute with a single click; or, you can even schedule it to run before you even make it to the office.
Script Executor will execute each script in the order you have defined against each database based on the mappings you have defined and once completed it will generate a comprehensive report allowing you to see how the script execution went on each target and also easily “flip through” the result sets that those scripts may generate.
Deploying (executing) multiple scripts against multiple SQL Server databases has never been easier.
You can download a free trial version of Script Executor from: http://xsqlsoftware.com/DownloadDetails.aspx?PackageID=40&ProdID=ScriptExecutorLic
A free community edition of Script Executor with limited functionality is also available: http://www.xsqlsoftware.com/Download.aspx
- SQL Server execute t-sql scripts
- SQL Server execute multiple scripts
- SQL Server deploy scripts to multiple databases
- SQL Server package t-sql scripts
- SQL Server run multiple scripts