3

I would like to be able to read the Dynamics NAV 2009 R2 Table Metadata directly from the SQL Server database without requiring the NAV Development Environment. This question is similar to Read Dynamics NAV Table Metadata with SQL but I need to access NAV 2009 R2 metadata and that answer doesn't work for me.

I found out that NAV 2009 uses some kind of compression algorithm on blob fields. I need to know what this algorithm is. Or may be any advises how to try to reverse engineer it. Turning compression off is not acceptable.

Vadim Kotov
  • 8,084
  • 8
  • 48
  • 62
Alexander Kuzin
  • 463
  • 4
  • 13
  • This should work. As the answer says there is no custom compression on blob fields. You just have to remove first 4 bytes from blob and then unpack it. – Mak Sim Nov 07 '14 at 12:19
  • I've tried it and it didn't work. It seems that in 2009 version compression algorithm is different. – Alexander Kuzin Nov 12 '14 at 08:47

0 Answers0