Options

NAV 2013 Technical Upgrade Problem

Jatin_PatelJatin_Patel Member Posts: 200
edited 2013-05-08 in NAV Three Tier
Hello,

I am upgrading NAV 2009 R2 W1 database to NAV 2013 W1.

I follow the below steps:

1. Create three folders on the computer and name them: OldBaseVersion, OldCustomVersion, and NewBaseVersion.
Completed
2. Complete the following series of actions twice: one time for the old base version of the Microsoft Dynamics NAV 2009 database, and one time for the old custom version of the Microsoft Dynamics NAV 2009 database.
a. Open the database using the Microsoft Dynamics NAV 2009 Classic client.
b. Delete all Dataports and forms from the database.
c. Export all objects in txt format into the appropriate folder: OldBaseVersion or OldCustomVersion.
Completed
3. Uninstall Microsoft Dynamics NAV 2009.
Completed
4. Install Microsoft Dynamics NAV 2013. Choose the Developer Option.
Completed
5. Complete the following series of actions twice: one time for the old base version, and one time for the old custom version.
a. Run the TextFormatUpgrade2013.exe tool on the contents of the OldBaseVersion and OldCustomVersion fold-ers to update all references to forms to be references to pages. For more information about the TextFormatUp-grade2013 tool, see TextFormatUpgrade2013 Tool.
Completed
b. Create a new database in the Microsoft Dynamics NAV Development Environment.
Completed
c. Import all objects. The TextFormatUpgrade2013.exe tool has saved the objects in a subdirectory of the original folder: C:\OldBaseVersion\Converted\AllObjects.txt or c:\OldCustomVersion\Converted\AllObjects.txt.
Error
when I import AllObjects.txt of OldBase version it will give error that you don't have the permission to create field.

The problem occurs because some field in Location table is available in OldBase version but not in NewBase version.
Field ID is in between 1-49999 nos.

so how we can move that field to NAV 2013 database?
Jatin Patel
Microsoft Dynamics NAV Consultant
Jatin's Blog

Comments

  • Options
    navuser1navuser1 Member Posts: 1,329
    The problem occurs because some field in Location table is available in OldBase version but not in NewBase version.
    Field ID is in between 1-49999 nos.

    Import Location table from OldBase version into NewBase Database using MERGE(Existing<-New) option and solve the issue first before do the rest of things.
    Now or Never
  • Options
    thegunzothegunzo Member Posts: 274
    You will need to base your NAV 2013 customized version on the CRONUS database supplied by Microsoft. You will apply the changes you made in your older database to the new one manually or with the help of a merge. The Mergetool.com is a good place to start.

    You should only upgrade new objects from older version to NAV 2013 with the method you described.
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
  • Options
    ara3nara3n Member Posts: 9,256
    you need to export the fob from your merged db instead of text file. Import the fob instead of txt file.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    dreamteamdreamteam Member Posts: 5
    Hi all,
    When you say OldBaseVersion and OldCustomVersion what do you mean? A standard Data base (Cronus) and the customized client Data base? Why you'd need a standard base version? :-k
    I understand that the TextFormatUpgrade2013.exe tool is enought to upgrade the no-standard objects, but for the standard objects it's necessary check the code exported in txt, one by one with a merge tool, like winmerge? for all of them? :?

    Thank very much!
Sign In or Register to comment.