Migrating from SQL 2014 32bit server to 64Bit for Nav 2009R2

Mathan

Hi everyone,

Would there be any issues with Nav 2009R2 when we migrate from SQL 2014 32 bit to Sql 2014 64 bit? Any help would be highly appreciated.

Thanks in advance.

Slawek_Guzek

Nope. Never heard of any problems with NAV caused by upgrading the SQL server from 32 to 64 bit version.

If you are over cautious and have enough time available you can make NAV native backup
(fbk), connect to new server, create new database on it and restore NAV backup there.

kriki

I can confirm it. No problem whatsoever.
It might be a little faster because SQL Server can use more memory for caching, locks, execution plans,.... But somehow, I don't think that is a problem.

Slawek_Guzek

Nope. Never heard of any problems with NAV caused by upgrading the SQL server from 32 to 64 bit version.

If you are over cautious and have enough time available you can make NAV native backup
(fbk), connect to new server, create new database on it and restore NAV backup there.

kriki

I can confirm it. No problem whatsoever.
It might be a little faster because SQL Server can use more memory for caching, locks, execution plans,.... But somehow, I don't think that is a problem.

Mathan

Thank you all for the insights.