SoftOve

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 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.
3) Choose which databases to target 4) Add one or many script steps

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.

5) Split into batches and select result destination folder 6) Check the progress and messages for each database 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.
7) View the results instantly or save them for later use 8) Option to compare the results to find differences
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 Comparision Table

FeatureSmuds LiteSmuds
Execute queries and commands on multiple databasesYesYes
Number of queries to execute for each databaseUnlimitedUnlimited
Execute queries within transactionsYesYes
Pause executionNoYes
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
Maximum number of batches29999
Save configuration fileNoYes
Open configuration fileNoYes
Command line supportNoYes
Access Smuds from within SSQL Server Management StudioNoYes
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
Option to exit application when finishedNoYes
PriceFreeView prices

Changelog

To find more about fixes and changes in earlier versions of Smuds, see the Changelog.

Name Comment Send