Database Syncing

Hi…

Today we are doing a DB upgrade in Dynamics 365 for Operations. One of the steps in the process includes installing a hotfix which in turn triggers a database sync. The Sync failed so I tried to find a way to run it manually and since the environment is a TEST environment it does not have Visual Studio. Powershell to the rescue:

I:\AosService\WebRoot\bin\Microsoft.Dynamics.AX.Deployment.Setup.exe -bindir "G:\AosService\PackagesLocalDirectory" -metadatadir "G:\AosService\PackagesLocalDirectory" -sqluser "axdbadmin" -sqlpwd "[PasswordForAxDBAdmin]" -sqlserver "Servername.database.windows.net" -sqldatabase "[SQLAzureDB]" -setupmode "sync" -syncmode "fullall" -isazuresql "true"

 

Links:
https://community.dynamics.com/ax/b/axilitynet/archive/2016/01/28/ax7-database-synchronization-w-o-visual-studio

Leave a Reply