is it possible to Convert/upgrade native Nav 4.0 sp1 DB to Nav 5.0 SQL Server DB?

hello,

Is it possible to Convert/upgrade native Nav 4.0 sp1 DB to Nav 5.0 SQL Server DB?

if possible,can anyone guide me the complete procedures in step by step manner…

will it give any major drawbacks ?

If you want to do a full upgrade, you need to wait for the upgradetoolkit.

Split your project in 2 steps; first the upgrade to 5.0 on native, see how that works and then move to SQL.

We have seen some very ugly behaviour on SQL2005 and you absolutely want to make sure it is not the NAV software but SQL before you start implementing the solutions and workarounds.

Hello Marq,

Ugly behaviour in the sense that Navision SQL 2005 DB is not handling the SIFT functionality properly(performance is very slow) .Am i right?

Well, yes and no…

The SIFT that was built into SQL is not so nice but that can be changed and optimised pretty straigt forward.

Biggest issue today is the caching of execution plans which can completely destroy your system and is unsolvable; we only have a bunch of workarounds.