Database Version Numbers in NAV

From Dynamics

Jump to: navigation, search

NOTE
This article was hard to read and incomplete. A new article NAV platform updates is being maintained to make it much better.

Thanks to Waldo and Dean McCrae for the information
David Singleton 13:29, 18 June 2008 (MST)

Internally since Navision has been available on SQL, the 

DatabaseVersionNo field in the $ndo$property table

has contained the information about which version of the database you are running. This is to duplicate functionality that was in the Native DB to prevent the user connecting to the Server with a client designed for a different database.

Also look at NAV version history for details of the actual versions of NAV and Navision. The article on NAV platform updates gives an over view of the Updates.

Contents

[edit]

Database versions for: 2.50

1  : Beta 1 data formats

2  : Beta 2 data formats (change in Code field value format from space-padded prefix to hex prefix)

3  : Beta 3 data formats (change in Code field value format from hex prefix to no prefix or special format)

4  : Release data formats (SIFT trigger identifiers changed and new indexes on SIFT tables)

[edit]

Database versions for: 2.60(A->C)

5  : Release data formats (change in Session view and SIFT triggers to use CONVERT rather than CAST for datetime fields)

[edit]

Database versions for: 2.60(D->F)

6  : Changes in SIFT triggers due to UPDATE... WHERE... performance problem

[edit]

Database versions for: 3.00

7  : Beta 1 data formats (change in Session view for SQL Server 2000; change in chartable)

8  : Beta 1 data formats (change in chartable; changes in SIFT triggers due to UPDATE... WHERE... performance problem)

9  : Beta 1 data formats (added maintainviews dbproperty)

10  : Beta 2 data formats (mapped invalid characters to "_" for SQL object identifiers)

11  : Release data formats (added diagnostics dbproperty)

[edit]

Database versions for: 3.01, 3.01A, 3.01B

12  : Release data formats (added identifiers dbproperty)

[edit]

Database versions for: 3.10, 3.10A

13  : Release data formats (added maintainrelationships dbproperty)

[edit]

Database versions for: 3.60

14  : Release data formats (change in Session view for new extensions; identifer conversion dbproperties; per-database license dbproperty)

[edit]

Database versions for: 3.70

15  : Release data formats (change in chartable; added checkcodepage, quickfind, maintaindefaults dbproperties; change in Session view for new extensions and column COLLATE; change in Database File view for column COLLATE)

16  : [Hotfix 5] data formats (change in Session View for removing duplicate connections based on 'sysprocesses.ecid')

17  : [Hotfix 12] data formats (change in Session View for removing duplicate connections based on 'sysprocesses.ecid'; the identifiers and invalididentifierchars dbproperties are updated to OEM)

18  : [3.70B] data formats (change in Session View, removing join to syslockinfo; also removed from session count query)

[edit]

Database versions for: 4.0

20  : Pre-release data formats (change in Session view for new Idle Time column; change in permission table to include new object types)

30  : [SP 2] Security release data formats (change in Session view, removing join to syslockinfo; change in chartable; creation of security objects)

40  : [4.1 SP 2] Release data formats (added locktimeout, locktimeoutperiod, hardrowlock and bufferedrows dbproperties)

50  : [4.2 Update 3] No actual database conversion was made

60  : [SP 3] Release data formats (alterable security option; fix for SIFT data corruption around Closing Dates; added securityoption dbproperty)

61  : Rebuilding SIFT triggers in order to correct the Sum problem

62  : Rebuilding SIFT triggers in order to correct the delete statement

63  : [SP 3 Update 8 Build 26565] Prevention of updating SIFT twice

[edit]

Database versions for: 5.0

80  : Release data formats (added system tables for office integration and record links; change in table descriptions for clustered property)

81  : Rebuilding SIFT triggers in order to correct the Sum problem

82  : Rebuilding SIFT triggers in order to correct the delete statement

95  : [SP 1] Removed SIFT tables and triggers, creating Indexed Views instead

[edit]

Database versions for: 2009

120 : Pre-release data formats (incl. CTP1) (added several new system tables; extended record links system table)

130 : Pre-release data formats (incl. CTP2) (removed SIFT tables and triggers, creating Indexed Views instead)

140 : Pre-release data formats (removed Assembly and Relationship system tables; added enabledforservice dbproperty)

150 : NAV 2009 SP1

[edit]

See also

[edit]

External links

Retrieved from "http://wiki.dynamicsbook.com/index.php?title=Database_Version_Numbers_in_NAV"
Personal tools
Ads: