•set up your scripts and servers once, and run multiple times•deploy maintenance scripts across multiple servers fast•set up multiple server lists for different tasks•retrieve data from multiple servers in a single dataset•supports MySQL, Oracle, and PostgreSQL
Do you manage multiple servers for multiple purposes in your work? Do you want to be able to run sets of scripts on multiple server concurrently, from a single application? Wouldn’t it be nice to be able to view the results of the scripts from your servers in a single consolidated result set, instead of individual result sets for each server?Then give SQL Multi Select a try. It does all the above and more, to make your job of managing your servers easier. Let’s take a look at how SQL Multi Select meets each of the above requirements.
Manage multiple serversYou can set up multiple lists of servers for different purposes. For e.g. you may have different server lists for test, production, or QA.
Run sets of scriptsSimply add the scripts you want to run to a project. You can also edit the scripts from within SQL Multi Select.
Single consolidated result setData retrieved from multiple servers are displayed in a consolidated result set. The origin of the data is also displayed, so you can quickly tell from which server and database the data was retrieved from.
Export your result setsNeed to share your consolidated result sets? SQL Multi Select can export your result sets to text files and even into a SQLite database. Need to compress those files? That’s taken care off too, with zip and 7-zip compression options.
Easily modify your project optionsYou can quickly exclude scripts or servers from your project run simply by unchecking the appropriate item. Very convenient if you want to test a single script, or run scripts on a particular set of servers.
Get started with SQL Multi SelectRun scripts on multiple servers with a single click- try SQL Multi Select free for 14 days
Got a question?If you need help, or have any questions about SQL Multi Select, please get in firstname.lastname@example.org
Dynamic database listsUse regular expression filters to include or exclude databases from your projects. With this, any new databases that meet the filter criteria are automatically included (or excluded) from your project.
Easily filter your result setsYou can quickly exclude the results from one or more servers from the result sets simply by unchecking the appropriate servers.
Group your servers easily using query groups.
Before running your project, you can easily skip scripts and servers you don’t require.
To hide the results from a server, just deselect it from the server list.
Imagine how SQL Multi Select can help you do your work faster. Need to create a new user account on a set of servers? Just select the appropriate query group, write the script, and run the project. Need to create a new database on a bunch of servers? Prepare the CREATE DATABASE script, select a query group, run the script, and you’re done. The possibilities are endless.Here are some other SQL Multi Select features that you might just find useful.
View image and blob detailsSQL Multi Select can display thumbnails and details of your images in the result sets.
Run your scripts fasterYou can configure the number of server and database threads in your projects. This allows you to run your scripts on multiple servers in parallel, meaning results are returned faster.
Schedule your projects to run periodically (Standard and Professional Edition only)Easily set up and run daily maintenance and health check scripts so that you have a record of your databases’ settings and statistics, using the SQL Multi Script command-line interface.
•PostgreSQL 7.4 up to 9.6•MySQL 6.0, 5.5, 5.1, 5.0, 4.1, 4.0, and 3.23•Oracle 12c, 11g, 10g, 9i, 8i, 8.0, and 7.3
Supports multiple database enginesSQL Multi Select can run scripts on MySQL, Oracle, or PostgreSQL query groups. That’s almost like having 3 products for the price of one.