Black Tambourine — Sitecore 8 Azure PaaS Part 2

Sitecore 8 Azure PaaS Part 2 - Azure SQL Configuration

There are multiple ways to get the Sitecore databases deployed to Azure SQL, here is my preferred method. I won’t go into detail on how to use the Azure dashboard, refer to this page for more info https://azure.microsoft.com/en-us/documentation/articles/sql-database-get-started/

1) Your development environment should be a blank local install of Sitecore and it’s SQL databases; set this up if you have not already.

2) Create an Azure SQL Server if you do not have one already. Ensure that these have the same location as your Web App from Part 1.

3) Open the Firewall settings for the Azure SQL server and allow your client IP address.

4) Create a new blank Azure SQL database for Sitecore’s “Web” database within the Azure control panel.

5) Download this tool for migrating local SQL Databases to Azure SQL:

6) Run the SQLAzureMW application and select “Analyze/Migrate - Database” then click Next.

7) Enter the connection details of your local Sitecore “Web” database and then click Next.

8) Choose “script all database objects” and click Next. Click Next on the summary page.

9) Click Next when the scripts are completed, you will then be asked to enter the credentials of the Azure SQL “Web” database. Click Next.

10) Click Exit when the scripts have finished.

11) Repeat steps 4-10 for the Master, Core, Session and Reporting databases.

12) Update the “connectionstrings.config” file of your Web App from Part 1 to the Azure SQL databases (e.g. use FTP to upload an updated file).

e.g.