Creating and Managing the Dynamics NAV2015 Multi-Tenant Environment –Using Development Shell

1. Import NAV Admin tool from NAV Dir.

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\80\Service\NavAdminTool.ps1'

2. Stop NAV service

Set-NAVServerInstance DynamicsNAV80 –Stop

3. Export NAV Application object to seperate database

Export-NAVApplication -DestinationDatabaseName NAV15-APP -DatabaseName "Demo

Database NAV" -DatabaseServer TEST-DEV -ServiceAccount "domain\user"

4. Remove NAV Application from database.

Remove-NAVApplication -DatabaseName "Demo Database NAV" -DatabaseServer TEST-DEV -Force

5. Update NAV Middle tier for use a Tenant database structure

Set-NAVServerConfiguration -ServerInstance DynamicsNAV80 -KeyName DatabaseName -KeyValue ""

6. Restart Dynamics NAV Server

Set-NAVServerInstance DynamicsNAV80 -Start

7. Mount Application Database to Dynamics NAV Middle tier Service

Mount-NAVApplication -DatabaseServer TEST-DEV -DatabaseName NAV15-APP -ServerInstance DynamicsNAV80

8. Mount Company database to Tenant which is contain two companies (CRONUS Canada, Inc. and CRONUS USA, Inc.) in My Demo database

Mount-NAVTenant -Id Default -DatabaseServer TEST-DEV -ServerInstance DynamicsNAV80 -DatabaseName "Demo Database NAV" -OverwriteTenantIdInDatabase

9. Save the NAV tenant configuration in Middle tier service

Save-NAVTenantConfiguration -ServerInstance DynamicsNAV80

10. Move Companies to Tenant database

      Import powershell script from installation folder/media,

      Eg:  C:\Temp\Dynamics.80.NA.1538476.DVD\WindowsPowerShellScripts\Multitenancy

 Import-Module "C:\temp\Dynamics.80.NA.1538476.DVD\WindowsPowerShellScripts\Multitenancy\NAVMultitenancySamples.psm1"

HowTo-MoveCompanyToTenant -ServerInstance DynamicsNAV80 -FromDatabase "Demo Database NAV" -CompanyName "CRONUS Canada, Inc." -OldTenantName Default -NewTenantName CRONUSCAN -ToDatabase CRONUSCAN -DatabaseServer MSSIAP-DEV -ServiceAccount "Domain\user" -RemoveCompanyWhenMoved

11. Create new database and create new company in Multi-Tenant envoirment

      To create New database, open SQL Management Studio and create a new database

      name: NAV2015-TEST-T1DB and then,

Mount-NAVTenant -Id TESTT1 -DatabaseServer TEST-DEV -ServerInstance DynamicsNAV80

 -DatabaseName NAV2015-TEST-T1DB

12. Sync New Tenant

Sync-NAVTenant -Tenant TESTT1 -ServerInstance DynamicsNAV80

13. Create New Company in New Database

New-NAVCompany -CompanyName NAV2015-T1 -ServerInstance DynamicsNAV80 -Tenant TESTT1

15. Get List Tenants under the NAV Server Instance

Get-NAVTenant Dynamicsnav80 |Format-Table

Export All Object and Split into single text file Using Microsoft Dynamics NAV2015 Development Shell

1.Export All application objects from NAV Database to text file,

Export-NAVApplicationObject NAV2015AP-APP-TEST “E:\NAV2015-Objects\All-Objs\NAV2015-All-Objects.txt

Example with filter
Exports codeunits 80..84 from the NAV2015AP-APP-TEST to COD80-84.txt

Export-NAVApplicationObject NAV2015AP-APP-TEST “E:\NAV2015-Objects \COD80-84.txt -Filter 'Type=Codeunit;Id=80..84'


2. Splits a text file that contains more than two application objects into separate text files for each object.

Split-NAVApplicationObjectFile -Source "E:\NAV2015-Objects\All-Objs\NAV2015-All-Objects.txt" -Destination E:\NAV2015-Objects\Text\

This is make is easier to using team foundation to maintain such as history of the objects, version control and etc.

NAV Report – RDLC ROW Background Color Iteration

NAV Report – RDLC ROW Background Color Iteration

 BackgroundColor

Background color for Column heading

 

Expressions

In report  properties you can change the color base on expressions.

 

create an expression,

=IIf(RowNumber(Nothing) Mod 2, "Yellow","Khaki")

Result