Skip to main content

Data Migration Steps From NAV 2013 to NAV 2013 R2.

Hi All,

This was asked to me from so many readers about the steps that we need to take for data migration from NAV 2013 to NAV 2013 R2.

Yes those steps are listed in MSDN but at the same time they are so much confusing as they have merged the steps of both Data Migration as listed below-

1. NAV 2009 / SP1 / R2 TO NAV 2013 R2.
2. NAV 2013 TO NAV 2013 R2.

So for those who are looking for steps that need to be executed to upgrade data from NAV 2013 to NAV 2013 R2, do read the post.

PREPARATION

1. Update the Application Code.
Any customization in the customer’s old database must be implemented in the new database.

2. Export all the objects in the new customized Microsoft Dynamics NAV 2013 R2 database to an object file: objects. Fob.

3. Prepare for the data conversion.

a. Make sure that you are the only user connected to the database.

b. Back up the database and save the backup file in a safe place.

c. Make a copy of the customer’s database in SQL Server Management Studio. You will upgrade the copy and keep the original.

d. Verify that both your partner development license file and customer license file have been updated to Microsoft Dynamics NAV 2013 R2.

e. Identify a User ID and password for a superuser in the system or create a new superuser that you can use for the upgrade process. Log in as the superuser when you perform the upgrade.

f. Verify that you have the dbcreator and securityadmin Server Roles for the Microsoft Dynamics NAV SQL Server instance, using SQL Server Management Studio. To manage companies, objects, and licenses within a Microsoft Dynamics NAV database you must also have the db_owner database permission.

g. Disable integration properties for the database.

h. Open the database in the Microsoft Dynamics NAV 2013 Classic with Developer Environment.

4. Run a database test to determine the state of the customer’s database. 

Note: The database test can require a significant amount of time, depending on the size of the database.

5. Run the “Adjust Cost-Item Entries” batch job to ensure that the inventory cost data in the customer’s database is up to date. Run the job for each company in the database.

6. If your organization posts inventory costs to the Microsoft Dynamics NAV general ledger, run the “Post Inventory Cost to G/L” batch job. Run the job for each company in the database.

7. Make a copy of the Microsoft Dynamics NAV 2013 database, or create a backup.

Open the Microsoft Dynamics NAV 2013 development environment, and connect to the Microsoft Dynamics NAV 2013 database that you want to convert.

In the Microsoft Dynamics NAV 2013 development environment, on the Tools menu, choose Build Server Application Objects.

In the dialog box that appears, choose the Yes button. If any errors occur, they are shown in the Error List window. Make sure that you address all compilation errors before you continue.

8. In the Microsoft Dynamics NAV 2013 development environment, on the File menu, point to Database, and then choose Alter. 

In the Alter Database window, on the Integration tab, enter a check mark in the Save license in database field.

9. Next, you will convert the Microsoft Dynamics NAV 2013 database so that it can be used in Microsoft Dynamics NAV 2013 R2.

Before you start the following procedure, you can choose to uninstall Microsoft Dynamics NAV 2013. However, you can install Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 in the same environment.

When you uninstall Microsoft Dynamics NAV 2013, the database is still attached to the instance of SQL Server, which you can verify using SQL Server Management Studio.

10. To convert the database

Run the installation program for Microsoft Dynamics NAV 2013 R2. Choose to install the Developer option.

Open the Microsoft Dynamics NAV 2013 R2 development environment, and then connect to the Microsoft Dynamics NAV 2013 database that you prepared in the previous section.

In the dialog box that appears, read the instructions carefully because this action cannot be reversed.

When you are ready, choose the OK button, and then confirm that you want to convert the database.
Microsoft Dynamics NAV will now convert the database. This includes an upgrade of system tables, and an upgrade of all reports to support Report Viewer 2010.

When you are notified that the conversion was successful, choose the OK button.

11. On the Tools menu, choose License Information. Choose the Upload button to upload a valid Microsoft Dynamics NAV 2013 R2 license to SQL Server.

In the development environment, on the Tools menu, choose Build Server Application Objects, and then, in the dialog box, choose the Yes button.

UPGRADE STEP 1

1. In the following step, you will be connecting a Microsoft Dynamics NAV Server instance to the database.

2. Make sure that the service account that the Microsoft Dynamics NAV Server instance uses has the db_owner role for the database. Connect the Microsoft Dynamics NAV Server instance to the database, and then start the service instance.

3. Open the Object Designer, and then import Upgrade700701.1.fob. If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.

4. Then, from the Object Designer, run Page 104001, Upgrade - Old Version. Choose the Transfer Data button. Repeat this action for each company in the database. 

UPGRADE STEP 2

1. In the Microsoft Dynamics NAV 2013 R2 development environment:

On the Tools menu, open Options, and then, make sure that the Prevent data loss from table changes field is set to Yes. 

You must also make sure that the Server Name, Server Instance, and Server Port fields are filled in.This ensures that the Microsoft Dynamics NAV Server instance that is connected to the database will verify that no operation will cause loss of data in the development environment.

a. Import all customized objects in .fob format into the upgraded database. If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.

b. Make sure all objects are compiled.

Import Upgrade Step 2 objects from the Upgrade700701.2.fob file. If the .fob file contains objects with conflicting versions that are already in the database, the Import Worksheet window opens. Choose Replace All.

2. Open the Microsoft Dynamics NAV 2013 R2 Windows client to verify that you are connected to the Microsoft Dynamics NAV Server instance that is connected to the database being upgraded. 
Next, you will run Upgrade Step 2 in each company in the upgraded database. 

You can get a list of all existing companies in the database by running the Get-NAVCompany cmdlet and passing as an argument the Microsoft Dynamics NAV Server instance which is connected to the upgraded database. 

You will run objects directly from the development environment, so you must specify the company that the objects must run in in the Options window.

3. In the Microsoft Dynamics NAV 2013 R2 development environment:

a. On the Tools menu, open Options, and then, in the Company field, specify the name of the first company.

b. In the Object Designer, find page 104002 Upgrade - New Version, and then choose Run.

c. In the Upgrade - New Version window, choose Test Database Connection to make sure that the C/AL code that is triggered by the actions on the page has access to the database.

If your database is on a named SQL Server instance, you must specify the full name in the SQL Server Name field.  

d. Choose Transfer Data.
If the process is successful, and you don't have to revisit the upgrade logs, you can clean the content of the Upgrade Time Log  table. 

e. On the Navigate tab, choose Time Log, and then, in the Upgrade Time Log page, delete all records.
Close the Upgrade - New Version window, and then close the Microsoft Dynamics NAV Windows client.

4. Repeat step 3 for each remaining company in the database.

POST UPGRADE STEPS

1. When you have successfully transferred data in the last company, you must upgrade data that is common to all companies in the database, such as permissions, permission sets, web services, profiles and control add-ins.

2. Upgrade data common to all companies such as permissions, permission sets, web services, profiles and control add-ins.

If the customer has changed the Read/Write/Modify/Delete/Execute settings for any of the standard permissions, or customized default permission sets in any way, you must merge these changes into the default permissions sets and permissions that are included in Microsoft Dynamics NAV 2013 R2.

You can use XMLport 104001 Import/Export Roles and XMLport 104002 Import/Export Permissions to export the new default roles and permissions from the CRONUS International Ltd. demonstration database in Microsoft Dynamics NAV 2013 R2. 

You can add control add-ins in the Control Add-ins window in the Microsoft Dynamics NAV Windows client. For more information, see How to: Register a Windows Client Control Add-in. For example, the following client control add-ins are available from the Microsoft Dynamics NAV 2013 R2 product media: 
a. Microsoft.Dynamics.Nav.Client.BusinessChart
b. Microsoft.Dynamics.Nav.Client.PageReady
c. Microsoft.Dynamics.Nav.Client.PingPong
d. Microsoft.Dynamics.Nav.Client.VideoPlayer

3. Delete the upgrade toolkit objects.
a. In the Upgrade - New Version window, choose Mark/Delete Upgrade Toolkit

This deletes all upgrade toolkit objects, except tables. Tables need to be deleted manually after data deletion.

4. In the Microsoft Dynamics NAV development environment, delete the upgrade tables by setting a field filter for objects where the Version List contains Upgrade Toolkit Table - marked for deletion.

Hope you find the information useful.

Stay Tuned for More.

Regards,
Saurav Dhyani

Comments

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

RTC Report It is not possible to instantiate the Visual Studio bridge.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searchi...

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.