This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
I want to understand if there is an end of support date set for MDS which I couldn't find via https://zcusa.951200.xyz/en-us/lifecycle/products/.
We are evaluating MDS for a new solution. It appears to ticket all the boxes from functional/non-function point of view but there is a concern on (MDS) platform risk. I am keen to find out if there any information which might help with articulating the risk if there is any.
Background information:
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 75%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
When is the end of life (end of support) on Microsoft SQL Server 2019 MDS and DQS, I couldn't find via https://zcusa.951200.xyz/en-us/lifecycle/products/.
Do you have any updated information?
https://profisee.com/solutions/microsoft-enterprise/master-data-services/
I found this link says that MDS "Support ends in 2026", but this is not from Microsoft site, so I was wondering if we have official announcement from Microsoft.
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
MDS is part of SqlServer so it's supported thru the life of the SqlServer version. SqlServer 2019 is supported thru 2025. SqlServer 2022 has the feature and is supported thru 2028.
in some future version of SqlServer it may be declared deprecated, which means its fully supported in that version, but may be removed in a later version.
in practice, MDS is a mature technology not under active development, in fact some current features are being deprecated (may be removed in future version of SqlServer).
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 6%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Hi Eliot, thanks for the question. As discussed on the call today, to the best of my knowledge MDS is not yet deprecated and is still supported, however it likely won't get many (if any) feature updates in future. Likely any updates for MDS will only be security related. This article lists the deprecated features for MDS.
Logically speaking, Azure Purview is designed to take over a lot of what is in MDS and is probably the best place to start. However there are some caveats right now:
I also recommend you review the alternative options available in the market to ensure you get the best capability set (for your business) for the investment. If you do decide to move to MDS in Azure, I recommend you start thinking ahead about how you are going to replace or migrate off of MDS if/when it gets deprecated. I also recommend you regularly monitor its lifecycle closely and schedule regular assessments of alternate options.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Azure Purview is discovery and mapping of data sources. MDS does not of that. It's an MDM tool. Purview appears to have nothing to do with actually creating and maintaining data which is what MDS does. Purview is metadata and data dictionary. Nothing new here except it's a new Azure service. For years companies have purchased tools like this separately and for on-prem. We called them metadata tools. MDS is MDM, not metadata. They are completely different. I'm so confused why they are being compared.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 78%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Hi, I sat in on a session at the Microsoft Fabric EU conference this past week where this topic was mentioned, yet there is no public documentation. Where can we find this documentation?
Purview or MDS - which are you asking about? MDS documentation link can be found here https://zcusa.951200.xyz/en-us/sql/master-data-services/master-data-services-overview-mds?view=sql-server-ver16