April 12, 2010 at 18:12
filed under Dynamics AX
Tagged Database, Dynamics AX, Job, synchronize
Sometimes, you can’t synchronize a table because is contains duplicate records. This can occur when you change field lengths on a extended data type for example.
I’ve seen people write huge SQL statements, and even jobs that create these SQL statements to remove these duplicates from a table, but there’s actually a easy way to do this in AX.
Say you have a table KLFTestDuplicates that contains duplicates, then simple run the following job to remove them.
Remember: this is useful when developing and testing, but it will remove data from you database, so use it with caution.
no comments
RSS / trackback