Export NAV license from SQL Server

Microsoft Dynamics NAV does not give you an easy an option to export the NAV license from a SQL Server.

exportlicense1

You can upload to the server, or temporary change the license that is used in the development client, but you cannot download it again. Usually, that is not a big deal, you got your license file anyway, but in some cases, its practical to be able to export the license.

With NAV, the license can be placed in two different places, in the master database or in separate databases.

exportlicense3

If you check the “Save license in database”, the licens goes into the database, otherwise its stored on the server.

Introducing a simple tool to perform the export

exportlicense2

This tools will export the license file from the SQL server and database specified. If you leave the database field empty, the tools will export the license stored in the master database.

Download from here: ExportLicense

(13/2/2016: Updated to better handle SQL servers with different collations)

Or grab the source from github:
https://github.com/hougaard/ExportLicense

3 thoughts on “Export NAV license from SQL Server

  1. Hi Hougaard,
    I tried to run the app it does work when no database is specified as it reads the .flf on the SQL Server. However, when running with a real database, error pops saying “Invalid Column Name ‘License'”. The column name in the database is ‘license’, not ‘License’. Is that the problem?
    Thanks a lot!
    Eric91

  2. Awesome tool, thanks Erik! I lost count of the number of times I did an upgrade and came to the last part of loading the customer’s licence only to realise I don’t have a copy!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.