SMuds allows you to execute SQL scripts and queries targeting multiple databases. To decrease execution time the databases can be divided into batches and run in parallel. Values returned from the statements are added into one or more result tables presented when finished.
With a size of just about 200 kB the standalone EXE file, requiring no installation, can be kept on a USB stick or just downloaded whenever you need it.
The interface reminding about dialog windows in SQL Server Management Studio gives it a familiar tough. Along with the wizard like procedure this makes it extremely easy to get started and intuitive to use. Just follow the steps as described below.
1) In the About step you will find notifications about updates.
2) Enter database connection details.
3) Select which databases to target.
4) Add one or many script steps. Either by attaching a file or writing a script directly in the application.
5) Set the number of parallel batches to split the job into and setup the error handling.
6) Start the execution and view the progress along with messages for each database.
7) View the results from the script steps or save them for later.
If you want to repeat the same script later use the Save and Open buttons at the bottom left to save your configuration. Using the same configuration file the application along with the execution can be started from a command line allowing you to automate the process.
To request changes, report issues or give feedback send a mail to info{a}softove.com.
| Feature | Smuds Lite | Smuds |
|---|---|---|
| Execute queries and commands on multiple databases | Yes | Yes |
| Number of queries to execute for each database | Unlimited | Unlimited |
| Execute queries within transactions | Yes | Yes |
| Pause execution | Yes | Yes |
| Abort execution on errors | Yes | Yes |
| Continue with next step on error | Yes | Yes |
| Continue with next database on error | Yes | Yes |
| Number of databases to execute queries on | Unlimited | Unlimited |
| Number of servers to select databases from | 1 | Unlimited |
| View results from queries | Yes | Yes |
| Show Time statistics for queries | No | Yes |
| Show IO statistics for queries | No | Yes |
| Compare results and show differences | No | Yes |
| Save results to files | No | Yes |
| Save output from queries to files | No | Yes |
| Automatically save results and outputs when finished | No | Yes |
| Save configuration file | No | Yes |
| Open configuration file | No | Yes |
| Command line support | No | Yes |
| Price | Free | View prices |