We have approx 32,000 rows of data in our hrmvirtualnetworkhistory in DAX4. As AX2009 does not have ths table and Microsoft does not seem to offer any specific guidance or script on how to migrate the hrmvirtualnetwrokhistory data to new location in 2009 I am very interested to know how others handled this question.
One thing I can say (and I hope it helps) is that HRMVirtualNetworkHistory in Ax4 is now HRMVirtualNetworkTable in Ax2009.
Thanks for the input.; the HRMvirtualNetworkTable already exists in DAX4 and there is virtually no difference between DAX4 and 2009 with regards to this table. In DAX 4 the HRMvirtualnetworkhistry table has (or can have, and in our case does have) multiple records per employee in the same data area id. We store position history and virtually all our records have multiple records (transactions) . This HRMvirtualnetworkhistory table is gone in 2009 so the data from it must be dispersed to other tables, only MS give no guidance on this that I can find.
Even comparing a vanilla version of DAX4 to vanilla 2009 - DAX3 has an affiliation button where users hire and move employees and theese actions create hrmvirtualnetworkhistory (in vanilla the history is positoin / org unit and factor - not somethign I look forward to losing or re-building with zero guidance from MS).
Did you manage to sort out this issue in the end?
I don’t know if your company is planning to move to AX2012 soon but you may not be so pleased to know that HRMVirtualNetworkTable and the successor to the HRMvirtualnetworkhistory table (if not the same as the former) are both gone in AX2012 (i.e. marked as DEL_). I will be writing more on this in a new post later on.