Which databases are required in which environment?

Abstract

Required databases and the environment in which to use them.

A Sitecore Commerce solution can be deployed on internal and delivery networks. If you require a more secure deployment, the external databases can be run on the internal network. However, this could cause performance issues. Be aware of the following:

  • Sitecore XP

    • Create a Web database in the internal environment to allow you to preview content. This web database also means that the Web search indexes can be created ahead of time and copied to the production environment. By doing this, there is no delay in waiting for the “new” web data to index in the production environment.

  • Commerce Server

    • Do not use the same Commerce Server site for Content Management and Content Delivery. Instead, create two Commerce Server sites and use Commerce Server Staging (CSS) to move data between the two. Using the same site for Content Management and Content Delivery will cause any changes to catalog data on the Content Management site to be immediately published live to the Content Delivery site.

The following table lists the databases that are required for a Sitecore Commerce Solution:

Internal

Delivery

Sitecore

Master

Yes

Core

Yes

Yes

Web

Yes

Yes

Commerce Server

All

Yes

Yes

Microsoft Dynamics AX

AOS Databases

Yes

Channel Database

Yes