What is the difference between Sitecore's core, master, and web databases?

sitecore sitecore6
John picture John · Nov 12, 2012 · Viewed 13.1k times · Source

What is the difference between Sitecore's core, master, and web databases?

Answer

Dan Solovay picture Dan Solovay · Nov 12, 2012
  • Master: Contains all versions of all items. This is the database that content authors interact with, and is the default database used by the Sitecore Content Ediitor.
  • Web: This contains only the current versions of items. This is the database that supports the live website.
  • Core: This database has two purposes:
    1. It contains definitions for the Sitecore user interface (Content Editor, Page Editor, etc.). This is where you would go to add, for example, a new Right-click option to the Content Editor or a new ribbon button to the Page Editor.
    2. It contains the ASP.NET membership tables that drive authentication and security.

Related questions

The "TransformXml" task was not found (error MSB4036) on TeamCity build

Hello I have build server with TeamCity. My project is Sitecore Web Application. I am using TDS (HedgehogDevelopment). I have setup build settings in TeamCity with MS build and it looks like working when TDS project is disabled in build …

Read More
ASP .Net File Upload Maximum request length exceeded error

I have a simple ASP .Net file upload control on a page. I have following web.config settings <system.webServer> <security> <requestFiltering> <requestLimits maxAllowedContentLength="524288000" /> </requestFiltering> </security> </system.…

Read More
Query notation for the sitecore 'source' field in template builder

I am trying to set the the source field of a template using the query notation (or xpath - whichever works), but none of them seems to be working. My content tree is a multisite content tree: France --Page 1 ----Page1…

Read More