Master Data Services Database

Applies to: SQL Server on Windows Azure SQL Managed Instance

Important

Master Data Services (MDS) is removed in SQL Server 2025 (17.x). We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.

The database contains all of the information for the Master Data Services system. It is central to a Master Data Services deployment. The Master Data Services database:

• Stores the settings, database objects, and data required by the Master Data Services 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)