How to Publish to Azure

Here are the steps I took to get Rock running on Azure. This is not to say there is not another path, but only that this was the path I took after several other attempts.

1. Install a Windows Azure SDK
2. Created website in Azure (website mode "free")
3. Created SQL db in Azure
4. Added "RockContext" to Azure website connection string.
5. Allowed my IP to access Azure SQL via "firewall"
6. Changed web.config connection string back to standard (not use configSource=)
   1. added Azure SQL connection string into web.config including "MultipleActiveResultSets=True;".
   2. verify providerName="System.Data.SqlClient" is still in connection string <add tag.
   3. Added <customErrors mode="Off"></customErrors>
   4. Changed key="AutoMigrateDatabase" to value="True"
7. Added "MultipleActiveResultSets=True;" to Azure dashboard connection string as per StackOverflow.
8. Ran update-database (locally with laptop configured to point to Azure SQL db via Rock connection string.)
9. Download "the publish profile" from Azure
10. Right click RockWeb, and choose "Publish Web Site"
    1. Import profile (one-time)
    2. Did not check "Execute Code First Migrations" option in setting (could not get it to work)
    3. Restart website in Azure