Data restore from managed environments to Tier1 is long lasting procedure .  Sometimes we need data on urgent basis to trouble shoot some issues. Well you can connect to UAT DB directly from your dev machine. You just have to change  following values from web.config located at K:\AosService\WebRoot folder , it could be on  different drive depending on the machine you are using . Once you do these changes , just do IIS  reset and you are good to go.

image

For synchronization , you can use following command from the command prompt 

K:\AosService\WebRoot\bin\Microsoft.Dynamics.AX.Deployment.Setup.exe -bindir “K:\AosService\PackagesLocalDirectory” -metadatadir “K:\AosService\PackagesLocalDirectory” -sqluser “TempUser” sqlpwd “xxxxx” -sqlserver “xxxxx-91321ff8.database.windows.net” -sqldatabase “xxxxxx_fb7a785059678856” -setupmode “sync” -syncmode “fullall” -isazuresql “true”