Upgrade from SP 1 to Sp 3

JAYESH
JAYESH Member Posts: 290
edited 2007-12-05 in NAV/Navision Classic Client
Hi Experts,

Right now i have Navision 4.0 Sp1.
We are planning to upgrade Sp 1 to Sp 3.

Is there any way to convert Database from 4.0 Sp1 to 4.0 Sp3.

Be'z as per i know we can not back up and restore the objects from one version level to another.

I request you to please share your idea...

Thank you
JAYESH PATEL

Comments

  • kine
    kine Member Posts: 12,562
    In this case you just needs to open the database with the new client. The new client will convert the database to new version. If you will do backup and restore, you will have problems with clustered indexes on MS SQL (if I remember correctly).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ssingla
    ssingla Member Posts: 2,973
    But this will not be a complete upgrade. The modification/enhancement of code made in SP2 and SP3 will not be available.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Waldo
    Waldo Member Posts: 3,412
    If I remember correctly, you don't have to do a data migration. Just upgrade the objects, upgrade the client and server, and you're done.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • ssingla
    ssingla Member Posts: 2,973
    What will happen if a field is deleted from a table in SP2 or SP3 which has values.

    Further what about the modified objects?
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Waldo
    Waldo Member Posts: 3,412
    Then, you need datamigration tools.
    Afaik, there are no fields that were deleted ... don't you agree?

    The modified objects can be merged to a new version of the objects... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • JAYESH
    JAYESH Member Posts: 290
    Hi...

    I had done lots of changes in Codeunits..
    I am not clear how to do this..??

    There is not at problem about New Obects but the Codeunit,Table (Field which i included) which i modified in Sp1 what abt this ??

    How to work with Tables, Codeunit...
    JAYESH PATEL
  • Waldo
    Waldo Member Posts: 3,412
    You're asking how to upgrade objects? This is difficult to explain in a forum :| .

    I think you'll need the Upgrade Toolkit CD. All documentation you need is on there. Upgrade Quickguides, w1w1upgr.pdf, ... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • JAYESH
    JAYESH Member Posts: 290
    Hi...

    My question is Can i have to match each and every object which i modified in Sp1 and make a changes in Sp3 ??
    JAYESH PATEL
  • Waldo
    Waldo Member Posts: 3,412
    I do this with Araxis merge. This is a 3-way merge tool... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • JAYESH
    JAYESH Member Posts: 290
    HI..

    Can you send me that Tooll..or Link...
    JAYESH PATEL
  • DenSter
    DenSter Member Posts: 8,307
    www.google.com, type in Araxis Merge, click 'Google Search'. It should be the first link in the list.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • themave
    themave Member Posts: 1,058
    JAYESH wrote:
    Hi...

    My question is Can i have to match each and every object which i modified in Sp1 and make a changes in Sp3 ??
    Yes, that is why most people don't ever upgrade a heavly modified database. SP's don't add much functionality to justify the cost of upgrading. If a SP has a specific thing you need fixed, it will be cheaper to just program that change.

    as an end user, this is my single biggest gripe with the whole software maintenance program, you pay for the right to upgrade, you just can't do it without also paying to actually do the upgrade.
  • JAYESH
    JAYESH Member Posts: 290
    Thanks all for the information....
    JAYESH PATEL

Categories