We are about to upgrade a solution from Sitecore 9.1 to 9.2.
Is there a way to keep xDB in MS SQL?
Is MongoDB required and is it a bad idea to keep MS SQL?
-
are you using MongoDB for Sitecore 9.1? – Mahendra Shekhawat Sep 15 '19 at 17:11
-
No, thats why I’m asking. – Volodymyr Hil Sep 15 '19 at 20:30
-
If you are already in mssql, going from 9.1 to 9.2 in mssql is perfectly fine. – Chris Auer Sep 15 '19 at 22:48
Yes. MongoDB is legacy support now.
Best Practice is to use MS SQL for xConnect and xDB.
answered Sep 15 '19 at 22:29
You are on Sitecore 9.1 with xDB already in SQL and upgrading to Sitecore 9.2 than you don't require to use MongoDB. Even best practice is to use MS SQL or SQL Azure for xConnect and xDB, we generally try to avoid MongoDB.
The xDB Collection database can be hosted on:
- SQL Server
- SQL Azure
- MongoDB (Sitecore 9.0 Update 2 and later)
But if you really want to use the MongoDB, I would suggest you to go with MongoDB considerations - https://doc.sitecore.com/developers/90/platform-administration-and-architecture/en/mongodb-considerations.html
answered Sep 16 '19 at 3:23
Sitecore 9.2 gives you both options but doesn't enforce. If you have SQL in 9.1, you can keep it the same.
