We're in the process of upgrading our MDS instance, from 2017 to 2019, by means of a migration. I can't find any good documentation online on how to do this in an efficient way. Has anyone performed these steps and have some guidance to share?

Thanks in advance.

1 Answer 1


We ended up getting this to work by backing up the 2016 MDS database and restoring over the MDS database on the 2019 server. You have to open Master Data Services Configuration Manager after the restore, select the database and choose Upgrade Database (you may get an error about 'clr strict security' which we had to disable).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.