Header Ads Widget

LightBlog

Breaking

LightBlog

Wednesday, June 14, 2017

Incorporating Latest CU changes in Nav2016 client database using PowerShell (e.g. If you want to Incorporate GST changes)

#1.Load Modules
Import-Module "C:\Program Files (x86)\Microsoft Dynamics NAV\90\RoleTailored Client\Microsoft.Dynamics.Nav.Model.Tools.psd1" -Force

#2 save path for this activity 
cd "D:\GST\ClientName"

#OriginalPath = All Objects Of Customer's Base Nav Version(here Nav2016[CU13])
#ModifiedPath = All Objects Of Customer
#TargetPath    = All Objects Of Nav2016[CU20]


#3.Export All Objects Of Customer's Base version(here Nav2016[CU13])
Export-NAVApplicationObject .\CustomBase\CU13.txt -DatabaseServer 'INBOM-AXS8707NB\NAVDEMO' -DatabaseName 'CU 13 NAV 2016 IN' -LogPath .\

#4.Export All Objects Of Customer
Export-NAVApplicationObject .\Custom\ClientDB.txt -DatabaseServer 'INBOM-AXS8707NB\NAVDEMO' -DatabaseName 'Client DB Live' -LogPath .\

#5.Export All Objects Of Nav2016[CU20]
Export-NAVApplicationObject .\Target\CU20.txt -DatabaseServer 'INBOM-AXS8707NB\NAVDEMO' -DatabaseName 'CU 20 NAV 2016 IN' -LogPath .\


#6.Compare & merge
Merge-NAVApplicationObject -OriginalPath  .\CustomBase\*.TXT –ModifiedPath .\Custom\*.txt -TargetPath .\Target\*.TXT -ResultPath .\Result\

#7.Join all txt objects to one
Join-NAVApplicationObjectFile -Source .\Result\*.txt -Destination .\ClientNav2016WithCU20.txt

#8.Import ClientNav2016WithCU20.txt to Client Database.
#9.Resolve the conflict
#-------------------------------------------END------------------------------------------
#Note==>Incorporating GST in NAV using PowerShell

#If you just want Incorporating GST then use below 3 step and rest all(6 to 9) steps will same
#OriginalPath = All Objects Of Customer's Base Nav Version(Without GST)
#ModifiedPath All Objects Of Nav[With GST]
#TargetPath    = All Objects Of Customer

No comments:

Post a Comment

Adbox