CONTACT US

568-3-53 (3rd Floor) Kompleks Mutiara 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia 6012-9714904 support@yohz.com https://www.yohz.com

RESOURCES

product blogs video tutorials help files
Copyright © 2005 - 2019 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners
Do you manage multiple servers for multiple purposes at work? Do you want to be able to run sets of scripts on multiple server concurrently, using 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? Try SQL Multi Select. It does all the above and more, to make your job of managing your servers easier. Manage multiple servers You 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 scripts Don’t limit yourself to a single SQL command, or to a single script. Run multiple SQL commands in a single script, or even run multiple scripts in a single project. SQL Multi Select will display all the result sets returned by the commands and scripts. Single consolidated result set Data 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. Imagine how SQL Multi Select can help you do your work faster. Need to create a new user account on a group of servers? Just select the server group, run the CREATE USER script, and you’re done! Need to create a new database on a group of servers? Prepare the CREATE DATABASE script, select a server group, run the script, and you’re done! The possibilities are endless! Export your result sets - Professional Edition license required Need to share your consolidated result sets? SQL Multi Select can export your result sets to text files and into a SQLite database. Need to compress those files? That’s taken care off too, with zip and 7-zip compression options. Share your result sets - Professional Edition license required Export your result sets into a SQLite database, and your end-users can use the FREE SQL Multi Select Viewer to view the result sets too. Dynamic database lists Use 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. Modify your project options with a few clicks You 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. Easily filter your result sets You can quickly exclude the results from one or more servers from the result sets simply by unchecking the appropriate servers. Schedule your projects to run periodically - Professional Edition license required 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. View image and blob details SQL Multi Select can display thumbnails and details of your images in the result sets. Run your scripts faster You 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. Supports multiple database engines SQL Multi Select can run scripts on MySQL, Oracle, PostgreSQL, or Firebird servers. That’s like having 4 products for the price of one. Are you a PostgreSQL user? Take a look at our blog comparing SQL Multi Select with pgAdmin 4 (1.4), and see what SQL Multi Select has to offer.
To hide the results from a server, just deselect it from the server list.
Group your servers easily using query groups.
Before running your project, you can easily skip scripts and servers you don’t require.
Run multiple scripts on multiple servers with a single click using SQL Multi Select
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, PostgreSQL, and Firebird
DOWNLOAD NOW
Get started with SQL Multi Select Run scripts on multiple servers with a single click - get the Basic Edition for FREE!
Got a question? If you need help, or have any questions about SQL Multi Select, please get in touch. support@yohz.com
Download FREE Basic Edition Download FREE Basic Edition See help file See help file

CONTACT US

568-3-53 (3rd Floor), Kompleks Mutiara, 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia 6012 9714904 support@yohz.com https://www.yohz.com

RESOURCES

product blogs video tutorials help files
Copyright © 2005 - 2019 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners
Run multiple scripts on multiple servers with a single click using SQL Multi Select
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, PostgreSQL, and Firebird
Download FREE Basic edition Download FREE Basic edition

Do you manage multiple servers for

multiple purposes at work?

Do you want to be able to run sets of

scripts on multiple server concurrently,

using 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?

Try SQL Multi Select. It does all the above and more, to make your job of managing your servers easier.

Manage multiple servers

You 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 scripts

Don’t limit yourself to a single SQL command, or to a single

script. Run multiple SQL commands in a single script, or even

run multiple scripts in a single project. SQL Multi Select will

display all the result sets returned by the commands and

scripts.

Single consolidated result set

Data 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.

Imagine how SQL Multi Select can help you do your work faster. Need to create a new user account on a group of servers? Just select the server group, run the CREATE USER script, and you’re done! Need to create a new database on a group of servers? Prepare the CREATE DATABASE script, select a server group, run the script, and you’re done! The possibilities are endless.

Export your result sets

(Professional Edition)

Need to share your consolidated result sets? SQL Multi Select can export your result sets to text files and into a SQLite database. Need to compress those files? That’s taken care off too, with zip and 7-zip compression options.

Share your result sets

(Professional Edition)

Export your result sets into a SQLite database, and your end- users can use the FREE SQL Multi Select Viewer to view the result sets too.

Dynamic database lists

Use 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. Modify your project options with a few clicks You 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. Easily filter your result sets You can quickly exclude the results from one or more servers from the result sets simply by unchecking the appropriate servers.

Schedule your projects to run periodically

(Professional Edition)

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.

View image and blob details

SQL Multi Select can display thumbnails and details of your images in the result sets.

Run your scripts faster

You 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.

Supports multiple database engines

SQL Multi Select can run scripts on MySQL, Oracle, PostgreSQL, and Firebird servers. That’s like having 4 products for the price of one. Are you a PostgreSQL user? Take a look at our blog comparing SQL Multi Select with pgAdmin 4 (1.4), and see what SQL Multi Select has to offer.
To hide the results from a server, just deselect it from the server list.
Group your servers easily using query groups.
Before running your project, you can easily skip scripts and servers you don’t require.
See help file See help file Compare Compare