web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Active Discussion

Migration AX 2012 to D365 recommendations about huge table

(0) ShareShare
ReportReport
Posted on by 2,475

Hello Every one and Good day .

I need your RECOMENDATIONS about data Migration from AX2012 to D365

The scenario is : We have a very big database size (1.6 TB) When we start to replications to D365 it taken 2 days and 23 Hours . then when we start upgrade on LCS taken 9 HOURS then Error message appear we opened case with Microsoft they noted that the (size exceeded 4 TB ) and asked us to comperes data and clean to descries size of data , anyhow . we cleaned data in ax 2012 all Modules but still size around (1.4 TB).

Please advice which table we can not replicated at all for example ( Sales Table and sales line if all sales order invoiced we don't need it ) can I exclude these table ?

And other smaller table like (Purchase line)....

And which table I should be truncate before start replications Like (EVENTCUD table ).

Many thanks for your effort in advance

  • nathanclouse Profile Picture
    30 on at

    Hey Khaled,

          I'd start with standard functionality available to reduce the overall size of  your database. I wrote a series of articles on this at the following links:

    www.atomicax.com/.../cleanup

    www.atomicax.com/.../full-database-cleanup-routine-part-1

    www.atomicax.com/.../full-database-cleanup-routine-part-2

    www.atomicax.com/.../ax-2012-database-log-cleanup-automation (customization but worth reviewing)

    www.atomicax.com/.../ax-2012-aif-and-batch-cleanup-automation (customization but worth reviewing)

         If you've done all of that, please respond and i'll suggest some more ideas that are situation specific that may work for you.

  • Khaled Ahmed Profile Picture
    2,475 on at

    Many Thanks Mr. nathanclouse

    Yes we have done all of that ... Please advice us  .

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 512 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 386

#3
Adis Profile Picture

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans