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.