Technical upgrade from Navision 4.0 to 4.0 SP2

You can do Technical Upgrade from Navision 4.0 to Navision 4.0 SP2 by simply open Navision 4.0 database with the finsql.exe from Navision 4.0 SP2. When you open the Navision 4.0 database with the SP2 finsql.exe, Navision will first ask you whether want to upgrade to SP2 or not. If answer Yes to all the message to convert the database, Navision 4.0 SP2 will do the technical upgrade for you.

What the technical upgrade will do to your database. It actually update 1 table and 76 triggers in the old database when you do the technical upgrade.

The only table that will be upgraded is $ndo$dbproperty.


76 Triggers upgraded are:

1. BAS Calc_ Sheet Entry_TG
2. Company_Name$Action Message Entry_TG
3. Company_Name$Analysis View Budget Entry_TG
4. Company_Name$Analysis View Entry_TG
5. Company_Name$Bank Acc_ Reconciliation Line_TG
6. Company_Name$Bank Account Ledger Entry_TG
7. Company_Name$Bank Account Statement Line_TG
8. Company_Name$BOM Journal Line_TG
9. Company_Name$Calendar Entry_TG
10. Company_Name$Capacity Ledger Entry_TG
11. Company_Name$Contract Gain_Loss Entry_TG
12. Company_Name$Cust_ Ledger Entry_TG
13. Company_Name$Detailed Cust_ Ledg_ Entry_TG
14. Company_Name$Detailed CV Ledg_ Entry Buffer_TG
15. Company_Name$Detailed Vendor Ledg_ Entry_TG
16. Company_Name$Employee Absence_TG
17. Company_Name$FA Allocation_TG
18. Company_Name$FA Ledger Entry_TG
19. Company_Name$FA Posting Group Buffer_TG
20. Company_Name$Finance Charge Memo Line_TG
21. Company_Name$G_L Budget Entry_TG
22. Company_Name$G_L Entry_TG
23. Company_Name$Gen_ Jnl_ Allocation_TG
24. Company_Name$Gen_ Journal Line_TG
25. Company_Name$Ins_ Coverage Ledger Entry_TG
26. Company_Name$Interaction Log Entry_TG
27. Company_Name$Intrastat Jnl_ Line_TG
28. Company_Name$Inventory Buffer_TG
29. Company_Name$Issued Fin_ Charge Memo Line_TG
30. Company_Name$Issued Reminder Line_TG
31. Company_Name$Item Analysis View Budg_ Entry_TG
32. Company_Name$Item Analysis View Entry_TG
33. Company_Name$Item Budget Entry_TG
34. Company_Name$Item Ledger Entry_TG
35. Company_Name$Job Budget Entry_TG
36. Company_Name$Job Ledger Entry_TG
37. Company_Name$Maintenance Ledger Entry_TG
38. Company_Name$Opportunity Entry_TG
39. Company_Name$Phys_ Inventory Ledger Entry_TG
40. Company_Name$Planning Component_TG
41. Company_Name$Planning Routing Line_TG
42. Company_Name$Post Dated Check Line_TG
43. Company_Name$Prod_ Order Component_TG
44. Company_Name$Prod_ Order Line_TG
45. Company_Name$Prod_ Order Routing Line_TG
46. Company_Name$Production Forecast Entry_TG
47. Company_Name$Purchase Line_TG
48. Company_Name$Purchase Line Archive_TG
49. Company_Name$Reminder Line_TG
50. Company_Name$Res_ Capacity Entry_TG
51. Company_Name$Res_ Ledger Entry_TG
52. Company_Name$Reverse Auction Header_TG
53. Company_Name$Sales Line_TG
54. Company_Name$Sales Line Archive_TG
55. Company_Name$Sales Shipment Buffer_TG
56. Company_Name$Segment Line_TG
57. Company_Name$Serv_ Inv_ Line Price Adjmt__TG
58. Company_Name$Service Contract Line_TG
59. Company_NameCompany_Name$Service Invoice Line_TG
60. Company_Name$Service Ledger Entry_TG
61. Company_Name$Service Order Allocation_TG
62. Company_Name$Temp WHT Entry_TG
63. Company_Name$Temp WHT Entry - EFiling_TG
64. Company_Name$Unplanned Demand_TG
65. Company_Name$Value Entry_TG
66. Company_Name$VAT Entry_TG
67. Company_Name$Vendor Ledger Entry_TG
68. Company_Name$Warehouse Activity Line_TG
69. Company_Name$Warehouse Entry_TG
70. Company_Name$Warehouse Journal Line_TG
71. Company_Name$Warehouse Receipt Line_TG
72. Company_Name$Warehouse Shipment Line_TG
73. Company_Name$Whse_ Cross-Dock Opportunity_TG
74. Company_Name$Whse_ Internal Pick Line_TG
75. Company_Name$Whse_ Internal Put-away Line_TG
76. Company_Name$WHT Entry_TG

Navision 4 SP2 Windows authentication problem

After upgrade from 4.0 to 4.0 SP2 and syncronize your windows user Id, you are still not able to login to your database through windows login. You already grant all the necessary roles and permission to your users. You even grant them dbowner and super role, but still can't login. If you use database login, you can login successfully. If this happens to you, most probably is because you have not update the xp_ndo.dll file in you SQL Server Binn directory.

When you upgrade to 4.0 SP2, make sure that you update the xp_ndo.dll on all instance of your SQL Server. You can find the step-by-step instruction on how to update the file from the sql_esp folder in Navision 4.0 SP2 Disk 1 CD.

Navision Upgrade

I want to upgrade Navision 4.0 to Navision 4.0 SP2. I do not have any source of information for my upgrade except sourcing information from Internet forum. Below are the useful post / informations that I found regarding Navision upgrade:

Upgrade to Navision 3.7

Using 3.70 Server.exe on 3.10 data

Upgrade to Navision 4.0

Migrate of Navision 3.60 to the version 4
Navision 3.6--> Nav 4.0 Upgrade error
Upgrading Navision client 3.6 to 4.0 issues
V4 Client over 3.7 Database
Windows Permissions to Open Database
Restore Performance problem when upgrading from 3.60 to 4.00

Upgrade to Navision 4.0 SP1

Navision 4.0 to 4.0 SP1
Navision 4.0 Upgrade to SP1
Updating Navision 4.0 to 4.0 SP1
Upgrade from 4.0 to 4.0 SP1
Upgrade from Nav 4.0 to SP1 - when to convert database
SQL Errors upgrading from Nav370 to Nav4 SP1

Upgrade to Navision 4.0 SP2

Navision 4.00 SP2 released
Database Conversion from 3.60 to 4.0SP2 SQL Server option
MBS-Navision W1 4.0 SP2 Update
Upgread navision 4.0 SP1 to SP2
Upgrade Toolkit to upgrade 4.0 to SP2
nav 4.0 to nav 4.0 sp2 upgrade, adjust-cost error
Migrating From Navision SP1 to navision SP2
NAV 4.00 SP2 AND SQL2005?

Upgrade to Navision 4.0 SP3

Upgrade 3.7a - 4.0sp3 on SQL

Upgrading to 4.0 SP3
Technical upgrade to SP3
Upgrade from 3.70B to 4.00SP3

Upgrade from 4.00 to 4.00 SP3

Upgrade to SP3

Upgrade to Navision 5.0

Version 4 or version 5

Developer Toolkit

Why using Developper tool kit?
reliability of the Developer's Toolkit compare & merge
Dev toolkit problem with compare and merge

Others
Weaknesses of Navision