You can either execute the script for cloud-hosted, onebox VHD, or UAT environment. This is not applied with one-box Microsoft hosted environment.
Open PowerShell, run following script
1
2
3
4
5
6
7
| K:\AOSService\webroot\bin\Microsoft.Dynamics.AX.Deployment.Setup.exe
-bindir "K:\AosService\PackagesLocalDirectory"
metadatadir "K:\AosService\PackagesLocalDirectory"
-sqluser "axdbadmin" -sqlserver "." -sqldatabase "AxDB"
-setupmode "sync" -syncmode "fullall"
-isazuresql "false" -sqlpwd "************"
-logfilename "C:\Temp\dbsync.log"
|
For example
1
2
3
4
5
6
7
| K:\AOSService\webroot\bin\Microsoft.Dynamics.AX.Deployment.Setup.exe
-bindir "K:\AosService\PackagesLocalDirectory"
metadatadir "K:\AosService\PackagesLocalDirectory"
-sqluser "axdbadmin" -sqlserver "." -sqldatabase "AxDB"
-setupmode "sync" -syncmode "fullall"
-isazuresql "false" -sqlpwd "AOSWebSite@123"
-logfilename "C:\Temp\dbsync.log"
|
AX DB user you can get from LCS, if you want to sync Azure DB please change -isazuresql to True
You can also use d365fo.tools to trigger the DB sync.
Tier 1
1
| Invoke-D365DBSync -Verbose
|
Tier 2
1
| Invoke-D365DbSync -DatabaseServer .database.windows.net -DatabaseName db_d365opsprod -SqlUser JIT-6h8cg -SqlPwd NjT -LogPath "C:\Temp\d365fo.tools\dbsync.log"
|
