locked
MDS automated version locking/creation RRS feed

  • Question

  • Hi,

    I am wondering if it is possible to have an SQL job to lock old version + create new concurrent version of a model in MDS 2014. Also, can this be done without validation of the old version?

    My setup right now is that at the end of the month current version of the data should be locked and a new version should be created. It is important to not have a requirement that all members should be successfully validated to have this process (but it would be nice to have automated validation too). This process should not be manual. Is this possible? Any additional tips regarding this would be appreciated.

    Monday, January 25, 2016 10:28 AM

Answers

  • You can use WCF API to lock or commit a version and copy a version.

    https://msdn.microsoft.com/en-us/library/hh230994(v=sql.130).aspx

    Use MetadataUpdate to lock and commit a version.

    http://sqlserversamples.codeplex.com/wikipage?title=SQL%20Server%202012%20Master%20Data%20Services

    Use VersionCopyRequest to make a copy of a committed version.

    https://msdn.microsoft.com/en-us/library/microsoft.masterdataservices.versioncopyrequest.aspx

    You can lock a version with invalid the data, but to commit a version, that requires all the data are validated successfully. And version copy can only copy a committed version. So your scenario is not likely possible.

    • Proposed as answer by Vincent Chen (X) Monday, January 25, 2016 9:03 PM
    • Marked as answer by Alex_404 Wednesday, January 27, 2016 9:43 AM
    Monday, January 25, 2016 9:03 PM