Thanks in Advance.
We attempted to create a routine to export user security settings out of one environment and importing them into another using native functionality in AX 2012. One of the key tables, among others, is SecurityUserRole. Imagine our surprise when we could not find this table (and others) listed in the Import/Export select tables group even after selecting all possible options. We even searched the .dat file created for any name fragment, but found no matches.
We searched TechNet and found the article http://technet.microsoft.com/en-us/library/gg731855.aspx about the table groups in the Import/Export utility. It included a download for a spreadsheet of over 4,500 tables, and SecurityUserRole was not among them. There was a note however that read:
Note |
The preceding list does not include Kernel tables because Kernel tables are not associated with table groups. Additionally, we do not recommend that you export or import Kernel tables. The list also does not include tables that are used by the model store. |
So that left us scratching our heads. Does AX 2012 have an approved way to move users from one environment to another with security role information intact?
I also found a blog that claims to show a way to copy a full company from one environment to another at http://microsoftfeed.com/2011/company-export-import-function-in-microsoft-dynamics-ax-2012/. It appears to have erroneous instructions. At one step it instructs to select the “All” tables group, which we could not find (please educate us if we are missing something). If you were to follow the intent and export all visible tables and import them into another company, then you would have an incomplete company based on our experiments.
We have been told with some authority that AX 2009 had the ability to copy a company from one to another using native functionality. We were also told that the same was true for moving users. Did AX 2012 really get released without these features?
Kind Regards,
Mark Simmerman