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 900 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. This is also where you enter your registration key if you chose to use the full version of Smuds.
2) Enter database server connection details. If your databases are located on several database servers or instances you have the option to add more servers.
3) Select which databases to target. Either by including or excluding specific databases.
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, setup the error handling and automation.
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.
8) To compare two results select this option in the Results button. Examine the result from a compare to see any differences. A typical use case is to compare the result before and after a change to make sure it works as planned.
If you want to repeat the same script later select Open or Save Configuration in the Configuration button. 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 an email 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 | No | 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 |
| Maximum number of batches | 2 | 9999 |
| Save configuration file | No | Yes |
| Open configuration file | No | Yes |
| Command line support | No | Yes |
| Access Smuds from within SSQL Server Management Studio | No | Yes |
| 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 |
| Option to exit application when finished | No | Yes |
| Price | Free | View prices |
To find more about fixes and changes in earlier versions of Smuds, see the Changelog.