Great series. Replicated all the steps and have it working except for one thing: When I drop the WeatherData db and run the MasterDeploy script, I get the following:
------------------------------------------------
[V1] Deploying WeatherData v1
[V1] Calling CreateWeatherData.test.sql...
Failure: WeatherData does not exist.
[V1] CreateWeatherData.test.sql called.
Msg 911, Level 16, State 1, Line 3
Database 'WeatherData' does not exist. Make sure that the name is entered correctly.
> DBVersion table exists.
> Dropping AddNewVersion stored procedure
...however if I highlight just the CreateWeatherData lines and run those first on their own, the database gets created and then I can run the MasterDeploy in its entirety. Any idea why it's getting stuck?