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.