How to move existing data from C/AL tables to AL tables?

nicolassaleron
nicolassaleron Member Posts: 11
edited 2019-01-27 in NAV Tips & Tricks
Hello,

We have an existing database with customizations developed in C/AL. We have moved the developments to AL on Business Central, thanks to txt2al tool.

And now, we do not know how to handle data...
What would be the "upgrade path" to move custom C/AL table data and custom field data in W1 tables to the all new extension?

Thank you in advance for your ideas.

Best Answer

Answers

  • TallyHo
    TallyHo Member Posts: 417
    edited 2019-02-01
    There is no official upgrade path yet as far as I know.
    Using different field or object numbers when upgrading to extensions
    is not an ideal solution to me.
  • nicolassaleron
    nicolassaleron Member Posts: 11
    Hello,

    Thank you for your answer, I was afraid of that :)

    Currently we think to implement the data migration by following this path:

    1. Convert objects and fields to AL with the same IDs. This will be our "Custom Extension"
    2. Create a C/AL tables and codeunit to move data to upgrade tables when C/AL tables and fields are removed
    3. Create an AL "Data Migration Extension" which has dependency on our "Custom Extension" and then copy data from C/AL upgrade tables to AL "Custom Extension" tables.
    4. Delete C/AL upgrade tables and AL "Data Migration Extension"


    I was also wondering if RapidStart can make the job on small databases...
  • ricardopaiva
    ricardopaiva Member Posts: 14
    Please take a look on my blog:


    https://ricardomoinhos.com/c-side-to-al-table-data-migration/

    This is a post from June 2019.

    https://ricardomoinhos.com/c-al-to-al-data-upgrade-automation-powershell-script/

    And this one is a tool to automate the data migration objects automatically.

    Plase let me hear from you. I hope this helps.
    Please leave your comments in my website as well.

    Regards,
    Ricardo Paiva Moinhos

Categories