Wednesday, May 2, 2012

How to reuse table Id in Dynamics AX

Sometime we created tables just for testing purpose within AOT and later on we delete these tables. In such cases we don't care about the IDs which are created for each table. There is a way to use these system generated IDs for other newly created tables. 

You can do this by following steps;

1.     Export the table with its current id.
2.     Delete the table
3.     Edit the xpo file and change the id to what you want
4.     Import the xpo file with the id option checked.  As long as the id is not used by something else, then it should get imported with that id.

No comments:

Post a Comment

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...