Switch the database source from master to web for SXA websites on CD server

Configuring the SXA CD server

In SXA, site definitions are done at the item level. This means that you do not have to restart a website after each change in the Sitecore.config file. You can create new sites with SXA without restarting your Sitecore instance.

You can change the site definition fields in sitecore/content/<tenant>/<site>/Settings/Site Grouping/<site>. You can also access these fields from the SXA Site Manager. The SXA site definition items are equivalent to Sitecore <site> nodes that you define within your config file if you build the site without SXA.

To know more about SXA site definition fields vist : https://doc.sitecore.com/en/developers/sxa/101/sitecore-experience-accelerator/the-sxa-site-definition-fields.html

You can Switch the database source from master to web for SXA websites on CD server as following:

To switch the database source from master to web:

1. Open Sitecore.XA.Foundation.Multisite.config and go to the  <siteManager> section.

Path: App_Config\Modules\SXA\Foundation\Sitecore.XA.Foundation.Multisite.config

2. Change the database attribute to web in the following section:

<add name="sxa" type="Sitecore.XA.Foundation.Multisite.Providers.SxaSiteProvider, Sitecore.XA.Foundation.Multisite" database="web" checkSecurity="false"/>

SiteManager Node: