How to Deploy Multi-tenant for D365 Business Central On-Premise using Azure SQL?


To deploy Multi-tenant environment for D365 Business Central On-Premise using Azure SQL. See below steps:

Step-1: Restore your database say "Demo Database (13.0)" in local SQL server Instance <database server>\<database instance> e.g. SQLSERVER\NAVDEMO

Step-2: Run Windows Powershell ISE as administrator and Create ".ps1" file and run below command:
Import-Module 'C:\Program Files\Microsoft Dynamics 365 Business Central\130\Service\NavAdminTool.ps1'

Export-NavApplication -DatabaseServer SQLSERVER -DatabaseInstance NAVDEMO -DatabaseName ‘Demo Database (13.0)’ -DestinationDatabaseName ‘Demo Database (13.0)_APP’

Remove-NavApplication -DatabaseServer SQLSERVER -DatabaseInstance NAVDEMO -DatabaseName ‘Demo Database (13.0)’

Please note: 
- ‘Demo Database (13.0)_APP’ is Application database and you have to use this database for all your customisation.
- ‘Demo Database (13.0)', is your business database or you can say its tenant database. You cannot use this database for any customisation. if you want to make multiple tenant then you can copy this database.


Step-3: Right click on each database, go to Task-> Deploy to Azure SQL Database. this is open wizard where you can connect your Azure SQL and upload both database one by one.

Step-4: Open Business Central Administration and opt your NAV Instance "DynamicsNAV130".

Step-5: Click on Edit->General, flag MULTITENANT =True. click on save

Step-6: Click on Edit->Database, Change database name to ‘Demo Database (13.0)_APP’ and database server to "xxxxx.database.windows,net". click on save

Step-7: Using powershell command upload business central license. See my next blog for this

Step-8: Click on Mount tenant as per below screen:

Step-9: Fill below form and click ok:

Step-10: Now your tenant is ready and you can access using below url:

RTC: <Servername>:7046/DynamicsNAV130/demo

Webclient: <Servername>:8080/DynamicsNAV130/?tenant=demo