Tuesday, March 28, 2017

Deploying Sitecore's Session Database to Azure

If you're using Sitecore 8.2 and up, you have the option of using Azure SQL. It's pretty easy to push all of the Sitecore DBs up to Azure, except for the Sessions DB. You need to run a quick SQL script to edit the database's schema before you can push it to Azure, otherwise you'll get errors.

From Oleg Burov's GitHub...
USE [Sitecore_session]
GO /****** Object: StoredProcedure [dbo].[CreateTables] ******/ IF OBJECT_ID('CreateTables') IS NOT NULL DROP PROCEDURE [dbo].[CreateTables]

If you need more details about how to get your Sitecore DBs out to Azure, Oleg has a nice guide on deploying to Azure.

No comments:

Post a Comment