13 Sep’17

D365 Business CentralConverting a Database from NAV 2016 to NAV 2017 in Microsoft Dynamics NAV

Introduction:

To upgrade the database to NAV 2017,  following main steps must be completed.

  • Convert the database
  • Upgrade the Application code
  • Upgrade the Data

This blog gives a steps wise procedure to covert the database from NAV 2016 to NAV 2017

Pre-requisites:

  • Microsoft Dynamics NAV 2016
  • Microsoft Dynamics NAV 2017
  • Microsoft SQL Server Management Studio(SSMS)

Steps

  1. Backup NAV 2016 Database   
    1. Open SSMS and connect to the SQL server.
    2. Expand the Database to NAV 2016 Database i.e ‘Demo Database (9-0)’.
    3. Navigate to Task > Back up.
    4. Click on Add then Navigate the path where you want to store the back up(.bak) file by clicking on the Assit edit button.
    5. Specify the file name then click on OK.
    6. A pop up displays after the back up of NAV 2016 database is taken.
    7. Clear all Microsoft Dynamics NAV Server instance records from the dbo.ServerInstance table in the database on SQL Server.You can do this by using SQL Server Management Studio to open and clear the table.
  2. Upload 2017 Licence file in NAV 2016 Database ‘Demo Database (9-0)’
    1. Navigate to File > Database > Alter.
    2. In the Integration tab, Enable Save licence file and select the licence file of NAV 2017 then click on OK.
    3. Alternatively, Select the Tools menu > Licence Information then Upload.
    4. Restart the NAV Server Instance in the Microsoft Dynamics NAV admin.
  3. Uninstall NAV 2016 and Install NAV 2017.
  4. Convert the NAV 2016 Database to NAV 2017.
    1. Open Microsoft Dynamics NAV 2017 Development Environment, select the NAV 2016 database i.e ‘Demo Database (9-0) and click on OK.
    2. Till will prompt to convert the database dialogue box.
    3. Click on OK. A confirmation dialogue box pops up.
    4. Click on OK. This will take few minutes. A message pops up once the database is converted.
  5. Connect the Server Instance to the converted database
    1. Open Microsoft Dynamics NAV Administration, Click on Add Instance.
    2. Specify a Server name and unique port numbers then click on OK.
    3. An instance is created, open the instance, click on edit, expand the Database tab.
    4. In the Database Name specify the converted database name then Restart the instance. In the below screenshot NAV90 is the server instance name for the converted database.
    5. Open the converted database in the NAV 2017 Development Environment. Navigate to the Tools menu > Options.
    6. Specify the Server Instance name, Server Port and the Management port.
    7. Click on OK.
    8. Make sure the user login has access to the Converted database.
      • Open SSMS, expand Logins and select the user.
      • Under the ‘Select a page’ tab, Select User Mapping, enable map for the converted database and master database and enable db_owner then click on OK

    9. Under master database, expand the Tables, select the Dbo.$ndo$srvproperty then properties.
    10. elect the Permissions then select the user and grant Select permission to the user.
    11. Restart the Server instance after applying the above permissions.
  6. Run the schema synchronization to initialize the database.
    1. Open the Microsoft Dynamics NAV 2017 Development Environment, navigate to Tools menu then click on Sync. Schema For All Tables > With Validation.
    2. This will pop up a dialogue box, click on Yes.
    3. After synchronizations, navigate to Tools menu > Build Server Application Objects.
      Building the application makes sure that the database is also synchronized in the SQL server and compiled.
    4. Building the application may lead to compilation errors which needs to be fixed.
      Follow the below link to fix .NET variable errors refer this link
    5. Build the Application again until the Build is successful.

Conclusion:

The database is successfully converted to NAV 2017. The next step is Upgrade the Application code for which you can refer this link

Written by

Chris D'Silva

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more