Overview

On a frequent basis I am being requested to recreate / move AX databases between environments.

DEV to UAT. PROD to UAT. GOLD to LOCAL. PROD to LOCAL etc.

This is not officially supported by MS, they recommended that the DB’s never move because there are so many references to settings on a per environment basis that you are likely to cause problems. Hence we never ever move a DB to PROD, we can move from and to any other platform for testing and development, but never to PROD. ​In most cases, this is not a problem but there are circumstances that need to be considered to get the restored database functioning.

When I first started to implement AX 2012 R3, I had been told that I have to manage users inside AX as well as manage users within Active Directory. I was not happy about this, so found the following method to support an AD based AX authentication process. The basic process for doing so is to query all AX Security Roles and export to CSV. Create AD Groups reflecting the Roles. Create AX User Groups reflecting the AD Groups. Finally add into the AX User Groups the AD Groups which reflect the AX Security Roles. First I needed to query AX for all the built in Roles