master-data-services-database.md

title	Master Data Services Database
description	The Master Data Services database contains all of the information for the Master Data Services system and is central to a Master Data Services deployment.
author	meetdeepak
ms.author	dkhare
ms.reviewer	mikeray
ms.date	03/05/2026
ms.service	sql
ms.subservice	master-data-services
ms.topic	concept-article
ms.custom	build-2025
helpviewer_keywords	database [Master Data Services], about the database database [Master Data Services]

Master Data Services Database

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

The database contains all of the information for the [!INCLUDEssMDSshort] system. It is central to a [!INCLUDEssMDSshort] deployment. The [!INCLUDEssMDSshort] database:

• Stores the settings, database objects, and data required by the [!INCLUDEssMDSshort] system.

• Contains staging tables that are used to process data from source systems.

• Provides a schema and database objects to store master data from source systems.

• Supports versioning functionality, including business rule validation and e-mail notifications.

• Provides views for subscribing systems that need to retrieve data from the database.

In This Section

• Leaf Member Staging Table (Master Data Services)

• Consolidated Member Staging Table (Master Data Services)

• Relationship Staging Table (Master Data Services)

• Staging Process Errors (Master Data Services)

See Also

Create a Master Data Services Database
Database Object Security (Master Data Services)
Database Logins, Users, and Roles (Master Data Services)