Insights

An Intro to Sitecore CMS databases for content authors

July 06, 2016

Like other CMS’s on the market, the Sitecore CMS uses multiple databases that separate stored content. Sitecore content authors should be aware of theses databases and how each affects them.

Let's begin.

After logging into Sitecore, you can access the screen below. If you are not seeing it, change the URL to http://mysiteurlhere>/sitecore/shell. You can view the available databases by selecting the small icon at the bottom right of your screen.

001.png

Let’s take a closer look at the databases.

4 databases for content authors  - TWO.png

The core database

The core database is where Sitecore stores settings such as users and roles. The Sitecore ribbon configuration is also stored here. This database is where the configuration will be stored if a developer wants to add a new button.

The master database

The master database is where content authors spend their time creating, deleting and editing content. None of these actions affect the live site. In order to change the live site, the content author must publish the item to the web database.

003.png

The action of publishing an item will transfer the item to another database – the web database.

The web database

The web database is responsible for the live site. Please be cautious, if you delete a published webpage then the content will be gone instantly.

The preview/staging database

Depending on your website’s build, there may also be a preview or staging database. This preview environment serves as a final test, before the content goes to production. The preview database also allows multiple users to access the website at one time to ensure all the right components have been published correctly before publishing an item (e.g. a full page). This step prevents the website or page from displaying any unexpected behavior once you hit “Publish”.

It is very important for Sitecore content authors to know the differences between these Sitecore CMS databases and to be aware of what database they’re working on at any given moment to avoid content-related mistakes!

Meet The Challenges Of Today's Digital Economy

Ready to take that first step and rise to your digital potential? Contact Valtech today.
Talk to Us