AX Tables: Copy all table data to another table

Sometimes there is a need to copy the data that is in one table into a new table. This can be due to synchronization issues where the data in a table may be lost, just wanting to tinker with the data, or whatever other reason you want. Here is a basic way to do this.

1. In the development workspace, right click on the table (we will call this daxTable) and select 'Duplicate'. This will create a new table. We will rename this table daxTable_Copy
2. Copy, paste, and run the below code into an AX job

Note that the recId and recVersion will not come over in this call. If other tables rely on this table's recId, this will screw some stuff up moving the data around.

// Copy data from one dropped table to another
static void daxCopyTableData(Args _args)
{
    DAXTable      daxTable;
    DAXTable_Copy daxTable_Copy;
    ;

    ttsBegin;
    // Clear the data from the copy table
    delete_from daxTable_Copy;

    while select daxTable
    {
        buf2Buf(daxTable, daxTable_Copy);   
        daxTable_Copy.insert();
    }
   
    ttsCommit;
}