locked
Re-assign version flag to another version automatically RRS feed

  • Question

  • Hi,

    I am wondering if there is a functionality in MDS to use some stored procedure to reassign a version flag to another version, basically this:

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

    I need to loop through several versions of the same model in MDS to extract data from all of them using the subscription views created with reference to one specific version flag (basically use one set of views to get data from many versions). So far I found that this can be done if I reassign the VersionFlag_ID to the versions I want in this table:

    SELECT * FROM mdm.tblModelVersion

    This seems dangerous though as the web interface has a check to not allow wrong type of flag to be assigned to non-verified version and it also auto deletes the flag from previous version.

    Can this functionality be achieved without manual web interface?


    • Edited by Alex_404 Tuesday, February 2, 2016 1:45 PM
    Tuesday, February 2, 2016 1:44 PM

Answers