RE: CreatedTime field dropped during synchronization during upgrade
Yatin
I would suggest you to go through the AX 2009 upgrade guide available at:
http://www.microsoft.com/downloadS/details.aspx?FamilyID=d9dae144-55b4-432d-b11e-f65ddb2d1b9c&displaylang=en
There is a specific section devoted to - upgrading date and time table field
pairs into UtcDateTime, in this document.
Hope this helps.
Regards,
Yatin
"Richard (DAX DEV)" wrote:
> Hi all,
>
> I am upgrading from AX4.0 to AX2009 SP1. We have auditing fields enabled in
> AX4.0 such as CreatedDate, CreatedTime, ModifiedDate and ModifiedTime in the
> PurchLine and PurchTable tables. In the AX4.0 SQL database, I can see each
> of these columns and before the synchronization step, I can still see these
> columns in the AX2009 database (restored from the AX4.0 database). During
> the database synchronization, I receive the warning message (among many) for
> these 2 tables indicating that they will be dropped. Continuing with the
> synchronization, surely, these fields in the AX2009 database are dropped.
>
> The weird thing with this is that in the SQLDictionary table, a record for
> the PurchLine CreatedTime and ModifiedTime fields exists which I thought
> would be renamed to "DEL_CreatedTime" and "DEL_ModifiedTime" is now gone
> after the sync. This also means that my new CreatedDateTime and
> ModifiedDateTime fields in the upgraded system does not have the appropriate
> time anymore.
>
> Has anyone come across this problem upgrading from AX4.0 to AX2009?
>
> Thank you for any help or information that you can provide.