wiki.dynamicsbook: Technical Upgrade to NAV 5.00 with End User license

[Blog bot]

Summary:



If you are planning a [[NAV technical upgrade]] to 5.00 may have discovered the "intentional feature" that makes it impossible unless you have a full developers license with access to all modify all tables in the database. Well here is a simple solution. its a bit convoluted, but will get you there.



NOTE this only works on SQL. Sorry if you have Native, then you need to go the Backup/Restore path.



* I create a backup of OBJECTS ONLY from your 4.00 database.
* Restore these objects into a new 5.00 database.
* Now export all table objects form this 5.00 database.
* Import all the 5.00 converted tables back into your 4.00 database.
* Close version 4 and open SQL Server Management Studio.
* Locate you 4.00 database, and open Table $ndo$dbproperty.
* Change databaseversionno from 60 to 80
* Now open your database in 5.00.

It take about 5 minutes, compared to a 20 hour backup restore

==See also==
*[[Technical Upgrade to NAV 5.00 with End User license]]
*[[Service Plans for Dynamics NAV]]
*[[NAV upgrade]]
*[[NAV database upgrade]]
*[[NAV technical upgrade]]
*[[NAV version history]]
*[[NAV developer license]]
*[[End User NAV developer license]]

[[Category:Glossary]]
[[Category:SQL]]

Источник http://wiki.dynamicsbook.com/index.php?tit...nd_User_license