Database Tools for SQL Server

SoftOve Multi Database Scripter

1) License texts and update notifications 2) Choose which database server to target 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.
3) Choose which databases to target 4) Add one or many script steps

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.
5) Split into batches and select result destination folder 6) Check the progress and messages for each database
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}
7) View the results instantly or save them for later use

Feature Comparision Table

FeatureSmuds LiteSmuds
Execute queries and commands on multiple databasesYesYes
Number of queries to execute for each databaseUnlimitedUnlimited
Execute queries within transactionsYesYes
Pause executionYesYes
Abort execution on errorsYesYes
Continue with next step on errorYesYes
Continue with next database on errorYesYes
Number of databases to execute queries onUnlimitedUnlimited
Number of servers to select databases from1Unlimited
View results from queriesYesYes
Show Time statistics for queriesNoYes
Show IO statistics for queriesNoYes
Compare results and show differencesNoYes
Save results to filesNoYes
Save output from queries to filesNoYes
Automatically save results and outputs when finishedNoYes
Save configuration fileNoYes
Open configuration fileNoYes
Command line supportNoYes
PriceFreeView prices

Name Comment Send