web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Classic SQL upgrade fr...
Microsoft Dynamics NAV (Archived)

Classic SQL upgrade from NAV5.0 to NAV2009R2

(0) ShareShare
ReportReport
Posted on by Colin van Viegen 115

Hi all,

I would like to replace the NAV5.0 client (5.0.26084.0) for the NAV2009R2 client (6.0.32012.0) and stay on Classic mode only.
The MS Upgrade Toolkit Manual mentions that I need to create a new empty NAV2009R2 DB and do a complete data conversion task including moving customizations to codeunits if they are now on current forms.

We were used to just open the database by a newer client and let it do a simple upgrade.
Will that still work if I open the current NAV5.0 DB with a classic 2009R2 client?

The only thing we want to have is a slightly better/stable NAS client (no extra 2009 features needed).
And no RTC for the current environment.

Just a quick win in stability.

Hope other members have great news for me.

Regards,

Colin

*This post is locked for comments

I have the same question (0)
  • Colin van Viegen Profile Picture
    Colin van Viegen 115 on at

    I forgot another reason for the upgrade.

    The current SQL Server 2005 environment has known issues with indexed views, so we would like to upgrade to SQL Server 2012 (which is compatible with NAV2009R2).

  • Suggested answer
    Rashed Profile Picture
    Rashed 3,765 on at

    We have some clients that have done this and it has worked for them.  Once change in cal code is that CASE Statement is case sensetive and two object a form were changed to make the variable uppercase.  There was a blog about this in MS site.  

  • Colin van Viegen Profile Picture
    Colin van Viegen 115 on at

    Thanks for your quick answer Rashed!

    Do you happen to have a link to the MS blog you mentioned?

    Regards,

    Colin

  • Verified answer
    Rashed Profile Picture
    Rashed 3,765 on at

    blogs.msdn.com/.../running-an-older-databases-in-nav-2009-runtime.aspx

  • Rashed Profile Picture
    Rashed 3,765 on at

    and this blog talks about enable the web services.  you can have an external scheduling system that connects to webservices and lets the service tier run the process.  

    blogs.msdn.com/.../upgrading-to-dynamics-nav-2009.aspx

  • Colin van Viegen Profile Picture
    Colin van Viegen 115 on at

    Great Rashed!

    So a exe only upgrade is still possible but I have to look into all matrix forms regarding the case sensitive bug. I'll first do the simple exe upgrade in a copy and test it thouroughly.

    thanks again for your help!

    Colin

  • Rashed Profile Picture
    Rashed 3,765 on at

    yes always do it in test environment and test and make sure everything works.

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,073 on at

    Hi Colin,

    As your information, you have done the migrate data part when open NAV5.0 DB with NAV2009R2 client. It is ok when you need only NAS client (may be you need to review some codeunits related to NAS) and no extra 2009 features, because the data structure between NAV5.0 and NAV2009R2 for classic client are the same. In future, if you upgrade to NAV2013 or NAV2013R2, you have to migrate application code part for NAV2009R2.

    However, it is recommended to do full NAV upgrade including 2 parts:

    - Part 1: migrate application code. For version NAV2009R2, you can use NAV Developer Toolkit or Merge Tool to build New Custom Version objects.

    - Part 2: migrate data. From version NAV5.0 to NAV2009R2, open NAV5.0 DB with NAV2009R2 client (no need data transform as NAV2009 to NAV2013, especially for Dimension structure), then import all New Custom Version objects.

    Hope this information can help you!

    Best regards,

    4BzSoftware@gmail.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans