Database Changes - Navision 4 SP3

Business Central/NAV Developers Forum
1

Hi,

Can anyone please explain about the changes that takes place on the database while upgrading to Navision 4 Service Pack 3 client? When the NAV 4 SP3 client is running for the first time, a message box is displayed saying that the database needs to be updated as per SP3 requirements. Would these changes affect the existing custom made dataports, etc.?

Thanks,

Vinod

2

yes, if those objects are part of the upgrade, they are affected!

3

If you are only upgrading client you shouldn’t get many problems. Open database with new client and select yes to upgrade.
But first do it in a test environment, because sometimes can be other external application that might not work after upgrade. (Jet reports, etc).

4

There are many changes from Nav 4.0 to 4.0 SP3. You should use the developers toolkit to compare the objects and do the changes needed.

5

If you are talking about just an executable change (which I think you are), typically things will all still work, but there is always an exception or two. Here are some examples of things I have come across while upgrading exectuables (not code) from one version to another, none of which are show stoppers:

  1. How permissions work may change a little.

  2. Passing of a RecordID variable from one function to another may not be allowed anymore

  3. Commands that have to do with Files and file pointers (instream & outstream) may change a bit

  4. Shell command may require different parameters

If you are on SQL you should really consider 5.0 SPI. I am in the process of upgrading this weekend (Code + Exectuables) and highly recommend some of the changes they have made in regards to SQL Performance.