How do I upgrade my existing MDS 2016 to MDS 2019/MDS 2022? And if it's possible then what is the challenges and how to mitigate those challenges?

Parmar, Kamlesh 0

I have recently migrated from on - prem to Cloud but with same configuration as on -prem. but now customer want to upgrade the MDS from 2016 to 2019/2022.

GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee

2024-03-01T21:22:16.24+00:00

Hi, @Parmar, Kamlesh Welcome to Microsoft Q&A thanks for posting your question.

Are you referring to Microsoft.Data.SqlClient (MDS) when you mention MDS? If that's the case, the MDS versions utilized in SSMS are 3.x (for SSMS 19.x) and 5.x (for SSMS 20). Prior versions of SSMS (18.x and earlier) used a distinct driver known as System.Data.SqlClient (SDS)

I am not clear on the problem you are facing can you please provide more details.

Regards

Geetha
Parmar, Kamlesh 0 Reputation points

2024-03-04T05:17:20.9133333+00:00

Hi, @GeethaThatipatri-MSFT Thanks for the response!
I'm actually referencing MDS as Master Data Service in Microsoft SQL server product for Data management.

We have lift and shift from On-prem to Cloud with same naming structure. but due to time constraints we didn't upgrade the SQL server, now we want to upgrade the SQL server from 2016 to may be 2019/2022. Don't know what the challenges will be.