1

I have installed Sitecore 9.2 XP0 Single Machine instance, using MS SQL Server for xDB. Now I have a requirement to replace MS SQL Server with Mongo DB for xDB. I have installed Mongo DB 4.0.5, as per the compatibility table. I need help on further steps on how to set this up. Do I need to manually create any DB instance inside Mongo DB, or are there any scripts for that?

4

MongoDB is an open-source database management system (DBMS), usually called NoSQL database that uses a document-oriented database model which supports various forms of data. It means you don't need to create any table or database also you don't need to run/create any script for this.

All you need to do some configuration changes, because the default Sitecore is configure with MSSQL. You can find the configuration changes in Installation Guide for the XP Scaled topology file under the 9.2 download section- https://dev.sitecore.net/Downloads/Sitecore_Experience_Platform/92/Sitecore_Experience_Platform_92_Initial_Release.aspx

Basic steps are as follow -

NOTE: The follow are done in the xConnect site (xconnect\App_Data\Config\Sitecore\Collection) and the Indexing service (xconnect\App_Data\jobs\continuous\IndexWorker\App_data\config\sitecore\Collection)

  1. Enable the sc.Xdb.Collection.Data.MongoDb.xml.disabled configuration file by removing .disabled extension.
  2. Disable the sc.Xdb.Collection.Data.Sql.xml configuration file by adding the .disabled
  3. Update the collection connection string to point to the MongoDB instance. It will look like this <add name="collection" connectionString="mongodb://127.0.0.1:27017/usms_collection" /> You must also update the collection connection string in the indexer job that exists under the following roles: enter image description here
  4. Rebuild the xDB search indexes in Solr. See the section Rebuild the Search Indexes in the link
  • 1
    +1 for a detailed answer. – Surya Sep 17 at 16:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.