The standard synchronization process is a single threaded process. This causes performance problems in larger upgradeslike AX 2012 RTM to R2, because we example add the partition column to all tables and indexes.
By using the DDL scripts we can push the sql server and disk system to the limit.
Please read the disclaimer when you hit the "Export Script".
How to implement the solution:
When it is finished there will be a general file with the tables that has 0-100000 records plus all views. All tables withmore than 100000 records will be in separate files.
There will be an INFO log at the end of the export with tables that are disabled by configuration keys.
Disregard this information as we in the code have continued the process without looking at these tables.
“Microsoft provides programming examples for illustration only, without warranty either expressedor implied, including, but not limited to, the implied warranties of merchantability or fitness for a particular purpose.
Kim Truelsen, Escalation Engineer
Big thanks to Jan Jensen, Columbus Danmark
good to know. best.