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

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) / Nav 2009R2 MS SQL Data...
Microsoft Dynamics NAV (Archived)

Nav 2009R2 MS SQL Database upgrade

(0) ShareShare
ReportReport
Posted on by Community Member

Hello all experts. We're running MS Dynamics NAV 2009R2 on MS SQL 2008 server and we need to migrate to MS SQL 2014 due to the close 2008 EoL.

Is an update suggested or shall we install a new instance then migrate all the data from 2008 to 2014 ? 

Thanks in advance for your advices

Br

Massimo

*This post is locked for comments

I have the same question (0)
  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    Install a new SQL 2014 instance, then restore the dB on the new instance.

  • Community Member Profile Picture
    Community Member on at

    oh, ok, thanks. I'd wanted to avoid to reconfigure all the clients with new instance name

  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    The new instance name is only for SQL Server, so you only need to change the SQL Server name in the NAV Service Tier settings. Client doesn’t need anything to do.

    Or you have NAV 2009R2 with CLASSIC CLIENT??? :O

  • Community Member Profile Picture
    Community Member on at

    Yes, we have 2009R2 with both RTC and Classic clients. 

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    Ok... if renaming the instance is a problem for your requirements you can certainly upgrade 2008 to 2014.

    I recommend to:

    1) Make first a full backup of your databases

    2) Start from SQL Upgrade Advisor:

    [View:https://technet.microsoft.com/en-us/library/ms144256(v=sql.120).aspx]

  • Community Member Profile Picture
    Community Member on at

    Thanks a lot Stefano for your advices. Really appreciated

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    Thanks to you. Please mark the question as solved.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans