Share via

Deprecated Master Data Services Features in SQL Server 2012

  • Article

This topic describes the deprecated Master Data Services features that are still available in SQL Server 2012. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.

Staging Process

The staging process that was used in SQL Server 2008 R2 is no longer available in the Master Data Manager web application; however it is still available in SQL Server Management Studio.

Staging errors from the SQL Server 2008 R2 staging process are no longer displayed in the UI. Error codes that are populated during the staging process are still available in the staging tables, and can be found here: https://msdn.microsoft.com/en-us/library/ff487022.aspx.

The staging tables (tblStgMember, tblStgMemberAttribute, and tblStgRelationship) are still available in the database. The stored procedure used to initiate the staging process (mdm.udpStagingSweep) is still available in the database.

The web service methods that call the staging process are still available.

The staging interval set in Master Data Services Configuration Manager applies to the staging process in both SQL Server 2008 R2 and SQL Server 2012.

A new, higher performance staging process has been implemented in SQL Server 2012. For more information, see Importing Data (Master Data Services).

Metadata

Though the Metadata model is still displayed in the Master Data Manager web application, it should not be used. It will be removed in a future release. Users can also no longer view metadata in the Explorer functional area, and you can no longer create versions of the Metadata model.

See Also

Concepts

Discontinued Master Data Services Features in SQL Server 2012