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
Thanks to you. Please mark the question as solved.
Thanks a lot Stefano for your advices. Really appreciated
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]
Yes, we have 2009R2 with both RTC and Classic clients.
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
oh, ok, thanks. I'd wanted to avoid to reconfigure all the clients with new instance name
Install a new SQL 2014 instance, then restore the dB on the new instance.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (