Loading...

Sitecore 9 - Deploy a SQL Server session database GOTCHA!

I recently needed to deploy a SQL Server session database for Sitecore 9.0 Update-1 and Sitecore documentation said following:

Select the Sitecore.Sessions.dacpac file and click Next. Note: the file can be found in Databases folder in the root of the Sitecore archive.

However, this is kind of misleading as there is no Databases folder. Also, there are no *.dacpac files to be found anywhere on the hard-drive either. It turns out Sitecore 9.0.1 rev. 171219 (OnPrem)_single.scwdp.zip contains the Sitecore.Sessions.dacpac. This is the case when you are setting up XP0 configuration. Simply take the file out of zip and put it somewhere where you can select it in Microsoft Sql Management Studio and continue following Sitecore instructions.

Hope this helps someone :)

Disclaimer
This is a personal blog. The opinions expressed here represent my own and not those of people, institutions or organizations that the owner may or may not be associated with in professional or personal capacity, unless explicitly stated.. In addition, my thoughts and opinions change from time to time I consider this a necessary consequence of having an open mind. This blog disclaimer is subject to change at anytime without notifications.