SQL Multi Script^™

SQL Multi Script is licensed per user and according to the maximum number of SQL Servers that the user can execute scripts against at one time. Activation does not require you to specify particular SQL Servers that you are going to be executing scripts against. This means that if you have a license for 5 SQL Servers, you can execute a set of scripts against any number of databases on up to 5 SQL Servers at once. It is easy to upgrade to purchase a license for additional users and SQL Servers. Please take a look at our pricing sheet or contact sales@red-gate.com for further information.

You can do this from the Database Distribution List, located in the top right-hand corner of the main window. From here, you need to click Configure to open the Configure Database Distribution Lists dialog. Expanding the listed SQL Server instances enables you to select the databases you want to add to your distribution list. You can create, save and edit lists as required. You can move any databases from your connected SQL Server instances into and out of your database distribution list by using the Add and Remove buttons. Click OK to save your new distribution list. The Database Distribution List will now display your new list. If you want to run a script against the default database, select the server and click Add. This will add the default database of the selected server to the database distribution list.

Prices start from $195 for a single user license for 5 SQL Servers. You can also purchase a single user license to use with an unlimited number of SQL Servers for just $495. Please see our pricing sheet or browse our Shopping Cart for more information on the user- and server- pricing combinations. If you have any questions about pricing, please contact our sales team

Yes. SQL Multi Script stops executing scripts against all databases if you manually cancel script execution or a parsing procedure (for example, by clicking Cancel), or if you exit SQL Multi Script while scripts are being executed or parsed.

Yes. In the top left-hand corner of the main window there are two blue arrow buttons, located under Scripts to Execute. The up and down arrows enable you to prioritize the execution order of your scripts in a list.

Yes. From the On Error drop-down menu above the Database Distribution List, you can specify how you would like SQL Multi Script to behave if there is an error during execution.

There are four options:

(1) SQL Multi Script can continue executing the script.

(2) SQL Multi Script can skip the script on the database that contains the error (but will continue to execute the next script in the list for that database. Script execution against all other databases in the distribution list that do not contain an error remains unaffected).

(3) SQL Multi Script can stop executing the script on the database with the error. SQL Multi Script will also stop execution of any further scripts for that particular database (but it will continue to execute scripts for other databases that do not contain the error).

(4) SQL Multi Script will stop executing all scripts on all databases.

Yes. SQL Multi Script will store your database distribution lists, even if you have created multiple lists.

Yes. If you click the Execute Now button, you can execute all the scripts in your list. If you want to execute just one script from that list, simply right-click on that script and select Execute This Script Only.

Yes. In Application Options, located on the Tools menu, you can select whether you would prefer your scripts to be executed serially or in parallel. If you would prefer parallel execution of your scripts, you need to select how many databases you wish to execute scripts against simultaneously (up to a maximum of 25). Parallel execution is recommended if you are executing scripts against databases on multiple SQL Servers. Serial execution is recommended if you are executing scripts against databases on a single SQL Server.

SQL Multi Script does not automatically save results if you exit the application. To save your results, click Save, located above the Messages tab in the Results window. You can save your results as a .csv or .txt file that can then be opened and used in other applications.

Yes. You can highlight specific scripts in the Scripts Executed pane in the Results window. If you highlight a script in isolation, SQL Multi Script will display results for that script. You can also uncheck boxes in the Executed Against pane to view results for separate databases.