Friday, October 21, 2016

DATA MIGRATION IN NAV 2016 FROM NAV 2009

DATA MIGRATION IN NAV 2016 FROM NAV 2009
Hi all,
Today i came across with different type of requirement, Sometimes we need to move/Copy our NAV data from one Database to others, OR One server to other server.
we can do this task using "Departments -> Administration -> Application Setup -> RapidStart Services for Microsoft Dynamics NAV -> Config. Package Card.
Note: In this scenario, BLOB fields are not copied, Due to overcome this we have to do using SQL Server.
But Now today i am going to talk about Data migration using Rapid Start Services.
Look guys, Earlier we are simply Export the Excel format and Import it, but in NAV 2016 if we go for import we will get exception, see the bellow screenshot.



To Overcome this we need to customize our NAV 2009 Objects, But before going i just want to tell you why this issue came.
See the bellow screenshot of NAV 2016 Excel file, there i marked PackageCode that are added.



You can also check NAV 2009 Excel, In that you can’t find PackageCode.
So now our job to add this PackageCode in NAV 2009 Excel file, To do this we have to customize several objects, these are as:
                Table ID                :               8613, 8614, 8615, 8616
                Form ID                                :               8614
                XmlPort ID          :               8610
                Codeunit ID        :               8611
                                In this Codeunit we have to upgrade 2 functions, these are as:
ExportSetupDataToExcel
CreateRecordNodes
Step 1:  Add the PackageCode field of type Code in Tables 8613, 8614, 8615, 8616.
In Table 8614 and 8615 give the Table relation to 8613 i.e. ”Migration Table”.
After adding the field write code for initializing the PackageCode, See the bellow screenshot.

               



Step 2:  Add codes in Codeunit 8611 ”Migration Management”, in this codeunit we have to upgrade two function as earlier i discussed. These are
                                ExportSetupDataToExcel
CreateRecordNodes
See the bellow screenshot for added code.



Find the ExportSetupDataToExcel function and update as like in screenshot.



Now update the second function i.e. ”CreateRecordNodes”, See the bellow screenshot
Note:    In Both images only the customize code, remaing Upper and lower code as in standard.
                Just match the code something like:
For ExportDataSetupToExcel find the CreateBook and start writting from screenshot, because some code are removed.
Also go thru something like other function called ”CreateRecordNodes”.





Now Compile, Save, Exit from this codeunit.

Step 3:  In this step we are going to upgrade XmlPort 8610 "Setup Data Schema" something like NAV 2016.
Design  XmlPort 8610 "Setup Data Schema" and upgrade as it is in bellow screenshot.



After designing the Xmlport Open the CAL Editor in this Xmlport only. And make changes



Now Compile, Save, and exit from this Xmlport.
Step 4:  Upgrade the Form 8614 ”Migration Overview” , Add the PackageCode field, so we can export.
See the bellow screenshot for Form, and update as it is.




Compile, Save & Exit from this form.

Step 5:  Now export the Data from Data migration, see the bellow screenshot.



Note: Whatever you given here PackageCode value that you need to give in NAV 2009.
Also remeber onething still it create a .xls file, So you have to just open and save as .xlsx format.
Also remeber one thing, if you are going to export multiple tables then you have to delete manually Sheet1 from exported file, it creates by default sheet1 extra. So to avoid exception delete manually sheet1.
See the bellow screenshot for exported excel file from NAV 2009 after upgraded.
Once the file is exported and save as with .xlsx, then you can import in NAV 2016 directly.


                                                       

Step 6 :                                         Now i am going to import this file. See the bellow screenshot.











7 comments:

  1. Hello binesh sir can i get your mail id or contact details to get explained over this error actually I m not technical person I m markering person my boss had given me to import all excel data into NAV within this week I had tried so hard but I m not able to process after this error now I had learn about how we can overcome from this error but I am not technical person so not able to understand

    ReplyDelete
  2. Hello, can you plz let us know the error or share your problems on mcabinesh@gmail.com

    ReplyDelete
  3. It is better to first read more about data migration solutions before selecting or making any of the decisions regarding data migration services. At the starting, I was not able to transform the data from one location to another due to which I had searched for the best service provider. Your company is one of the efficient data migration solutions providers.

    ReplyDelete
  4. I always appreciate your post.That is very interesting I love reading and I am always searching for informative information like this.
    Document Management Software India
    Document Management Software Mumbai
    Document Management Software
    Document Management System

    ReplyDelete
  5. I appreciate you for giving such an informative portal. Hire top nav consultant in delhi

    ReplyDelete
  6. The Microsoft Data Migration Assistant (ADMA) is a free download that helps you migrate your data to a new computer, a new version of Windows, or to a new Windows operating system. TheData Migration Assistant also helps you get your new computer ready for the migration, by running a series of checks and tests to identify any issues or problems with your current computer. You can then work with the Data Migration Assistant to fix any issues it finds.

    ReplyDelete

Popular Posts