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) / 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,166 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,166 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,166 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,166 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

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)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans