SQL Multi Script™
Walk-through 1: Using SQL Multi Script
This walk-through will show you:
- How to open and create scripts with SQL Multi Script
- How to set up a database distribution list to execute scripts against
- How to execute multiple scripts against multiple databases with a single click
- How to view and save the results
Stop walk-through
Step 4: Selecting how we want SQL Multi Script to behave in case of error
Before we execute the scripts, we can determine how we want SQL Multi Script to behave if there is an error on execution. This time, we will choose Stop executing. This means SQL Multi Script will stop executing against all scripts on all databases if there is an error. We can now execute the scripts. The first script will create the database schema, followed by the second script to populate the databases with our data, and finally a third script to query the database and retrieve data.




