locked
Model evolution - change attribute type RRS feed

  • Question

  • Hello,

    I am trying to make evolute a model in a new version by changing an attribute type - from string to int, for example.
    Can this be possible?

    Note that I am aware of the consequences, i.e. the need to validate the values in order to respect the new constraints.


    Marius
    Thursday, July 29, 2010 9:27 AM

Answers

  • Marius,

    We decided not to support type conversion on attributes after they are created. This would lead to a number of potentially destructive scenarios that would be difficult to test and support. We prefer that you migrate your data (export/import or business rule 'equals' action) from an old attribute to a new attribute and then delete the old attribute.

    Val

    Friday, July 30, 2010 4:49 AM
  • In SQL Server 2012, you still can't edit the attribute data type from within the SQL Server MDS website System Administration editors, but you can edit the data type of an attribute from the MDS Add-in for Excel, but there are still some restrictive limitations.

    More information here: http://msdn.microsoft.com/en-us/library/ff487008.aspx


    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

    Friday, February 22, 2013 10:59 PM

All replies

  • It is possible provided the strings values are convertible to INT datatype. You may find this article useful for data type conversion.

    Pradeep Adiga http://www.sqldbadiaries.com
    Thursday, July 29, 2010 10:58 AM
  • Pradeep,

    Thank you for your answer. I saw the article and I see it refers the data type conversion in SQL, whether I am talking aboud data type conversion at MDS application level. I mean I have an entity which have to change one attribute from string to integer. Now, in Administration section I cannot change the data type for an attribute after I have data added (it is disabled). Can you see my point?


    Marius
    Thursday, July 29, 2010 12:06 PM
  • Marius,

    We decided not to support type conversion on attributes after they are created. This would lead to a number of potentially destructive scenarios that would be difficult to test and support. We prefer that you migrate your data (export/import or business rule 'equals' action) from an old attribute to a new attribute and then delete the old attribute.

    Val

    Friday, July 30, 2010 4:49 AM
  • In SQL Server 2012, you still can't edit the attribute data type from within the SQL Server MDS website System Administration editors, but you can edit the data type of an attribute from the MDS Add-in for Excel, but there are still some restrictive limitations.

    More information here: http://msdn.microsoft.com/en-us/library/ff487008.aspx


    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

    Friday, February 22, 2013 10:59 PM