SQL Multi LoaderA useful tool for handling several scripts at once and working with more than one server at a time | |
Download |
SQL Multi Loader Ranking & Summary
Advertisement
- License:
- Demo
- Publisher Name:
- idbTools
- Publisher web site:
- http://www.idbtools.com
- File Size:
- 833 KB
SQL Multi Loader Tags
SQL Multi Loader Description
idbSQLMultiLoader loads sql-script on several MS SQL Servers. It stores list of connections and lets you operate with several servers in one click. Page "Settings" * Connections - you can add, edit, delete, copy, change connections order. Also you can load and save full connection list to ini-file. Set checkboxes to point, what servers you want to execute script on. Click on "Name" header will set all checkboxes or unset. * Tools - You can run tools with chosen server. Predefined tools are Query Analyzer and SQL Management Studio. * On error - choose action on error: Ask - show dialog box to ask user stop or continue; Stop - stop script running; Continue - Continue without message box. There is posibility to stop script in any case: to do that you need to execute operator raiserror('abort', 16, 1). * Connection timeout * Command timeout * No records - This flag sets no records are returned. In this case we can get print messages (first in every batch). It is ADO feature. * Output results and messages - turn on/off output of results and print-operator during script running. Errors will be still shown. * Check db_owner or db_ddladmin + db_securityadmin rights - check for user posibility to create db objects. * Column delimiter Tab - use tab symbol when show sql-results. Page "Script" Enter your SQL-script for MS SQL Server on this page. As a batch separator GO-operator is used. DB access Application uses ADO to access MS SQL Server.
SQL Multi Loader Related Software