Permalink
Find file
384ec44 Feb 8, 2016
@olegburov @ivansharamok
152 lines (90 sloc) 9.94 KB

How to deploy Sitecore databases to Azure SQL Database

This article provides a list of techniques that can be used to deploy Sitecore databases to Microsoft Azure using Microsoft SQL Server Management Studio.

Requirements:

  • A work or school account / Microsoft account and a Microsoft Azure subscription with the following Azure services enabled:
  • Microsoft SQL Server Management Studio 2014 Service Pack 1 or higher
  • Sitecore CMS and DMS 7.2 or Sitecore® Experience Platform™ 7.5 or higher

Note: See also How to deploy Sitecore databases to Azure SQL Database using PowerShell.

Instructions

The recommended approach to deploy Sitecore databases to the Microsoft Azure SQL Database service is as follows:

  1. Log in to the Microsoft Azure Portal using the https://portal.azure.com URL.

  2. In the Jumpbar, click the New button, then select the Data + Storage section and click the Storage button. The Storage account blade appears.

  3. In the Storage account blade, fill in the Storage field and configure the other section if needed, then click the Create button.

  4. In the Startboard, click on the Storage tile.

  5. In the Storage account blade, click the All settings button and select the Keys section. The Manage keys blade appears.

  6. In the Manage keys blade, copy the Storage account name and Primary access key.

  7. In the SQL Server Management Studio, update the Sitecore database schema to fit the Azure SQL Database service requirements:

  8. In the SQL Server Management Studio, in the Object Explorer window, right-click a Sitecore database, and select Tasks -> Export Data-tier Application... in the context menu. The Export data-tier Application dialog box appears.

  9. In the Export data-tier Application dialog box, click the Next > button to go to the Export Settings step.

  10. In the Export Settings step, select the Save to Windows Azure option and click the Connect... button. The Connect to Windows Azure Storage dialog box appears.

  11. In Connect to Windows Azure Storage dialog box, fill in the Storage account and Access key fields using the copied Storage account name and Primary access key from the Microsoft Azure Portal, then click the Connect button.

  12. In the Export Settings step, fill in the Container field and then click the Next > button to go to the Summary step.

  13. In the Summary step, click the Finish button to start creating a *.bacpac file.

  14. In the Results step, click the Close button when the operation is complete.

  15. Repeat steps 8-14 for each Sitecore database you want to export.

  16. In the Microsoft Azure Portal, in the Jumpbar, click the New button, then select the Data + Storage section and click the SQL Database button. The SQL Database blade appears.

  17. In the SQL Database blade, click on the Server section. Then create a new server configuration.

    Note: Sitecore recommends using Azure SQL Database server V12 to get the better experience. You must use SQL Server Management Studio 2014 Service Pack 1 or higher, which brings support for Azure SQL Database V12.

  18. In the SQL Database blade, fill in the Name field and configure the other section if needed, then click the Create button.

  19. In the Startboard, click on the SQL Database tile.

  20. In the SQL Database blade, click the Delete button in the top menu.

    Note: The Empty SQL Database is created with a SQL Server instance. However, it is not needed.

  21. In the Jumpbar, click the Browser All button and select the SQL servers from the list. The SQL servers blade appears.

  22. In the SQL servers blade, click on the SQL Server instance you created before. The SQL Server blade appears.

  23. In the SQL Server blade, click the Import database button in the top menu. The Import Database blade appears.

  24. In the Import Database blade, select the created storage account and container with *.bacpac file, then click the OK button.

  25. In the Import Database blade, configure the Pricing Tier section and fill in the Database Name, Server Admin Login and Password fields, then click the Create button.

  26. Repeat steps 24-26 for each Sitecore database you want to import.

Download Options

Exported Sitecore databases as *.bacpac files: