2014年9月25日 星期四

Clean a Microsoft Dynamics NAV Company

Quick and dirty way to clean a Microsoft Dynamics NAV company.

1. Create a new company under same instance.
2. Switch old and new company.
3. Set user's permission on new company.
4. Migrate all the custimized code to new company if need.
5. Remove old company.

PowerShell command example:

1. Create new company.
New-NAVCompany -ServerInstance "devilhouse" -CompanyName "devilroom_new"

2. Switch old and new company.
Rename-NAVCompany -ServerInstance "devilhouse" -CompanyName "devilroom" -NewCompanyName "devilroom_old"
Rename-NAVCompany -ServerInstance "devilhouse" -CompanyName "devilroom_new" -NewCompanyName "devilroom"

3. Set user's permission on new company. (I am using AD authentication for my solution. In different authentication model may need different user name format.)
New-NAVServerUserPermissionSet -PermissionSetId "SUPER" -ServerInstance "devilhouse" -UserName "ADDomain\JOHN_DEVILHOUSE.ADD" -CompanyName "devilroom"