Hardware and Sql Server Migration

Business Central/NAV Technical Forum
1

Hi All,

We planning to migrate the our Current Navision server

Windows Server 2003 to Windows Server 2008

sql server 2005 to Sql server 2008 R2 , currently we are using Navision 2009 SP1 ,(RTC version)

is this migration possiable or not if it is possiable than

what are precaution we have to taken before migration.

Regards,

Shailesh

2

Shailesh- We migrated our NAV environment about one year ago with the help of our partner here are a few things that we did (did not do but would do again)

  1. Do the users use the actual server name when they log onto NAV? If so i would implement a DNS record so next time you migrate to a new server you will not have to go to every user and tell them the new server name, you can just change the dns record and no one will be the wiser.

  2. If you are using enhanced security change the security model to standard, this can be done in single user mode. We had issues with table locking due to syncing all the users on a remote session and our sql server kept locking tables because the way the enhanced security model handles permissions.

  3. do not preform the migration the night before a holiday :slight_smile:

  4. Get help from your partner they will have done migrations many times and can advise further

3

Hello Sean,

Thanks for the reply, i just want to clear what the precaution i have to taken before hardware and sql server migration if you have any document regarding this can you share with me, because i don’t have partner this migration is done by me and my team, second thing i have read one pdf in which it has been mention that Navision 6.0 SP1 , is compatibility with SQL Server 2008 R2 and Windows 2008.

Email ID : Shaileshpandey85@hotmail.com

Skype Id : shailesh.pandey96

Regards,

Shailesh

4

need to migrate my current SQL server running DB mirror to a new SQL hardware. My plan is not to have any down time and at the same time since most