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 1: Creating and opening a new script with SQL Multi Script
On opening SQL Multi Script, it's easy to create new scripts or add existing saved scripts for deployment to our databases. To begin with a new, blank script, script1.sql is created for us. Right-clicking on our new script on the Scripts to Execute pane enables us to save it. To open an existing script we can click Add and browse to find the saved script. On this occasion, we will open an existing script called CreateSchema.sql; this script will create a schema on three databases for us.




