Activate change tracking using SQL only


  • Hello,

    We have a large number of entities already defined and we would like to add change tracking on numerous attribute. However the current user interface is not really suitable for that kind of batch operations so we would like to know if it is enough to set the tracking group number in the ChangeTrackingGroup column of the [mdm].[tblAttribute] table or if something else need to be done.

    Thank you for your answers,


    Donnerstag, 14. März 2013 13:53


  • Just answering to Myself in cases someone has the same question.Even if I'm pretty sure this table is enought to make the changes, if in doubt one can simply uses the webservices by

    - Request Metadata of the concerned Entity with MetadataGet() with the right MetadataResultOptions wich should be something like :

     	    MetadataResultOptions opt = new MetadataResultOptions();
                opt.Attributes = ResultType.Identifiers;

    Then once you have the webservice response just update every non-system attributes with the right change tracking group with something like 

    foreach (MetadataAttribute attr in answer.Attributes)
        if (!attr.IsSystem)
           attr.ChangeTrackingGroup = [The Group]

    Then update your MDS with MetadataUpdate()

    Et voila.


    Mittwoch, 24. April 2013 15:00