Export Blob Field

pschartzpschartz Posts: 3Member
edited 2018-10-05 in NAV Three Tier
Hello, I want to export a compressed Blob field to a file (in a decompressed state) so I can upload it to a MySQL db. The Data in the field are XML Files. I do only have read access to the SQL Server, therefore I cannot change any property neither create a NAV page etc. Please help. Regards Philippe

Answers

  • Slawek_GuzekSlawek_Guzek Posts: 1,612Member
    edited 2018-10-05
    Not possible in old NAV.

    Versions pre 2013 use bespoke compression alghoritm, so the only way is to make NAV to decompress the field before "plain text" data become available on the SQL Server table level.

    If you can't change anything in your production database install demo Cronus side-by-side, create or modify a table there which could keep your BLOB data, copy data between databases (even using a SQL query) and then change table definition in Cronus setting Compressed to No. NAV Client will decompress the data for you. You will be then copy uncompressed data to MySQL database.

    Unfortunately such a workaround is only good for one-off excercise of extracting data from NAV database.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • pschartzpschartz Posts: 3Member
    edited 2018-10-08
    Hi @Slawek_Guzek

    many thanks for your return.
    We're using Microsoft Dynamics NAV 2015 ... so what do you call "old NAV" ? :)

    Regards
  • Slawek_GuzekSlawek_Guzek Posts: 1,612Member
    edited 2018-10-08
    You have posted in "Navision Classic Client" - so I've assumed you are talking about NAV 2009 R2 or a prior version, as "Navision Classic Client" is for posting issues regarding thses versions only.

    NAV 2013 and onwards BLOBs can be decompressed using C# methods. Read this to find more details and sample C# code acceesing data in compressed BLOB fields outside NAV

    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • pschartzpschartz Posts: 3Member
    Well as 2015 is 3 years ago, I taught it would already be a Classic product :) :)
    Thanks I will have a look at this post ... but ... actually I'm looking for a webapp implementation, so C# won't do it
  • krikikriki Posts: 8,581Member, Moderator
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
Sign In or Register to comment.