SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Master Data Services: Copy Versions

In Master Data Services (MDS), you can use the Master Data Manager Web User Interface “UI” to copy a version of a model and create a new version of it (via the Version Management screen).  However, you may find the “Copy” icon on that screen grayed-out (although there is a bug where you can still click on the icon and the copy dialog box will pop up, which it should not.  But it won’t actually perform the copy).  To fix this, you need to go to the Master Data Services Configuration Manager and on the Database Configuration screen change the system setting “Copy only committed versions” to “No” (the default it “Yes”).  Then go back to the UI and click the “Refresh cached information” link on the top right of the home page and you will see that the “Copy” button is no longer grayed-out.

So obviously if you have model version that has a status mode of Open or Locked and want to copy it, you will need to make the above system setting change.  Because the default is to not allow this, it caused confusion on my part and hopefully this blog post will help you to avoid the same confusion.

It would be nice if the Version Management screen had a message on there as to why the “Copy” icon is grayed-out and how to fix it.

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...