Still working with the Microsoft Dynamics NAV 2013 database, but heard about how great the Microsoft Dynamics NAV 2013 R2 business solutions can be?

You are not alone. Many small and medium-sized businesses are jumping on the Dynamics NAV 2013 R2 bandwagon. Microsoft Dynamics NAV 2013 R2 is designed to streamline all business functions and lend automated technology to speed up operation processes from sales to shipping to increase your small business productivity. Especially suited for international deployments, you can now convert your existing Microsoft Dynamics NAV 2013 database to the Microsoft Dynamics NAV 2013 R2 technical requirements.

The conversion process requires three major steps:

  1. Preparing the database
  2. Converting the database
  3. Running the database through Microsoft Dynamics NAV 2013 R2

To prepare the database, ensure you are the only user connected to it.

Create a backup of the database and place it in a safe location.

Next, go into the development environment in your Microsoft Dynamics NAV 2013 and connect to the database you want to convert.

Click on the “Tools” menu and select “Build Server Application Objects.” A dialog box will appear asking you if you want to proceed. Choose “Yes.”

 build server






A list of compilation errors may appear at this point. You will have to address all errors before you can proceed with the next step. Once fixing the errors, select the “File Menu” in the development environment, go down to “Database,” and click on “Alter.”

An alter database menu will appear as you can go to the Integration tab and place a check mark in the box marked, “Save License in Database.” Click on the “OK” button and select the license file to upload as you can now move on to convert the database.

At this point, you can uninstall Microsoft Dynamics NAV 2013, although you may choose to keep it and install the Microsoft Dynamics NAV 2013 R2 in the same environment. After your decision, you can begin the conversion steps for the database.

1: Run the Microsoft Dynamics NAV 2013 R2 installation and select the “Developer” option. Open the development environment as you need to connect to the prepared Microsoft Dynamics NAV 2013 database.

2: A dialog box will appear with a set of instructions. Read all the instructions carefully as you will not be able to undo the following actions. Convert the database by clicking on the “OK” button to confirm the conversion.

 Mic Nav






3: You will receive a notification when the conversion is completed. Click on “OK” and then select the “License Information” option under the “Tools” menu. Select the “Upload” option to upload the Microsoft Dynamics NAV 2013 R2 license to your SQL server.

4: If any compilation errors and warnings occurred during this process, you will have to address them before running the converted database in Microsoft Dynamics NAV 2013 R2. You will see a list of the errors in the Error List window.

You can now run the converted Microsoft Dynamics NAV 2013 database in Microsoft Dynamics NAV 2013 R2. First, ensure that the service account for the database runs under the “db_owner” role. Then you can follow the below steps.

Begin the Administration tool in the Microsoft Dynamics NAV server and access the instance that you want to use with the database. Select the “Edit” button. Under “General FastTab,” change the fields Database Instance, Database Name and Database Server to the converted database you want to run and click on the “Save” button. A dialog box will appear.

Select “OK.”

Go to the left pane and run the modified service instance by selecting the right Microsoft Dynamics NAV server computer (Microsoft Dynamics NAV local). Right click on the service instance in the center pane and select “Restart” so the service instance can connect to the converted database.

The Microsoft Dynamics NAV server should now be able to access the converted database.



Like this post? Share it!