axStart: How to convert a column in a table to a different type with the same name without losing data.

[Blog bot]

Источник: http://axstart.spaces.live.com/Blog/...C0A0!255.entry
==============


Scenario:
You have decided to change the type of a table column from Integer to string. But you want the field name to be the same. On customer side you also want to convert the date. So the data is not lost.
Solution:
Development side:
·        Rename the old field to DEL_fieldname and create the new field Fieldname.
·        Add a configuration key SysDeletedObject30 to the DEL_fieldname.
Customer side:
·        Turn configuration key SysDeletedObject30 on.
·        Install the new layer or XPO. And synchronise the database.
·        Convert the data from DEL_fieldname to fieldname. With a job.
·        Turn the configuration key SysDeletedObject30 of.
Mission accomplished.
The SysDeletedObject30 configuration key is also used for migration from AX 3.0 to 4.0
Before you start the migration this configuration key needs to be active. After completing the migration, this key can be turned off. The column is deleted from the DB. Of course this concept can also be used on table level.


Источник: http://axstart.spaces.live.com/Blog/...C0A0!255.entry