MSDYN365BC 2019 Wave 2 - Setup a New Database?

Hi Readers,


As discussed in the last article, we will discuss steps to set up a new database with the Business central Wave 2 2019 release.

This is a long process so I would suggest the following steps when you have free time.

As there is no Development Environment all the steps need to be done via Powershell. So let's open Powershell ISE and start hacking.



Pre-Requisites -

• Create a Folder Install in C Drive.
• Copy BaseApp and System Application from Product DVD (Application Folder) into this folder.
• Copy Business Central Wave 2 License File in Install Folder.

1. Open Powershell and Create a New database as discussed earlier in this article.

• Database Name - Customer Database
• Database File Path - D:\Databases

New-NAVApplicationDatabase -DatabaseName "Customer Database" -DatabaseLocation "D:\Databases" -DatabaseServer "localhost"

2. Setup Service for New Database.

Create a new service tier BC150Blog and map it to the database.

3. Setup Web Server Instance for New Service.

Create a New Web Server Instance for BC150Blog Service. (Read Here)

4. Import Developer License in the database using Powershell as discussed earlier in this article.

Import-NAVServerLicense -LicenseFile <FilePath> -ServerInstance <ServiceName>

5. Restart Service Tier.

Restart-NAVServerInstance -ServerInstance <ServiceName>

6. Set Application Version for the database.
In this step, we will define the Build Number of Product for the database.
Set-NAVApplication -ApplicationVersion <ProductVersion> -ServerInstance <ServiceName> -Force

7. Set Application Family for the database. (Setting up Localization for the database)
In this step, we will define the Localized Version of the database. For World Wide Version we will use W1.
Set-NAVApplication -ApplicationFamily <Localization> -ServerInstance <ServiceName> -Force

8. Synchronize Tenant.

Sync-NAVTenant -ServerInstance <ServiceName> -Mode Sync

9. Publish System App Symbols

** Default Path is specified below. If you have changed the path during installation the update in cmdlet below.

Publish-NAVApp -Path "C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\150\AL Development Environment\System.app" -ServerInstance <ServiceName> -PackageType SymbolsOnly

10. Publish Microsoft_System Application

Publish-NAVApp -Path "C:\Install\System Application\Source\Microsoft_System Application.app" -ServerInstance <ServiceName>

11. Sync & Install System App

Sync-NAVApp -Name "System Application" -ServerInstance <ServiceName>

Install-NAVApp -Name "System Application" -ServerInstance <ServiceName>

12. Publish Microsoft_Base Application

Publish-NAVApp -Path "C:\Install\BaseApp\Source\Microsoft_Base Application.app" -ServerInstance <ServiceName>

** This step will take time as its the big set of object.

13. Sync & Install Base App

Sync-NAVApp -Name "Base Application" -ServerInstance <ServiceName>

Install-NAVApp -Name "Base Application" -ServerInstance <ServiceName>

14. Restart NAV Service Tier.

Restart-NAVServerInstance -ServerInstance <ServiceName>

15. Create a New Company in Database.
We cannot log in to a Database without a company. So let's create a company in the new database.

New-NAVCompany -CompanyName PROD -ServerInstance <ServiceName> -CompanyDisplayName PROD

16. Open Web Client.

With Business Central 2019 Wave 2, Microsoft has split objects into two apps - Business and Application.

These two apps are part of the product DVD in the Application Folder.

You Can Download Powershell cmdlet from GITHUB.

Hope you find the information useful.

Let me know your views as a comment on this article.

Stay tuned for more.

Regards,
Saurav Dhyani
www.sauravdhyani.com