Distribution of FOBs to several databases

AK
AK Member Posts: 226
edited 2017-07-28 in NAV/Navision Classic Client
We have something like 90 NAV 2009 R2 classic client databases with virtually the same objects and we have to import new objects manually in each and every one of them. Is there a tool which automates this?

Edit: We can't do a technical update to the later versions to use the finsql.exe parameters. For now we are stuck with what we have.

Comments

  • Juhl
    Juhl Member Posts: 724
    Then your out of luck.
    You could play with import of binary data, but have never tried it.

    Sounds like you need a central db with 90 companies instead. Cloud....
    Follow me on my blog juhl.blog
  • tomcollins
    tomcollins Member Posts: 5
    not sure about NAV 2009, but i would be surprised if the object manager advanced couldn't do this.

    https://idyn.nl/products/nav-development/object-manager-advanced

    check the "deploy" section. implementing the object manager advanced is a small project in itself though, and it isn't available for free.
  • AK
    AK Member Posts: 226
    A single database with multiple companies is just not feasible at the moment. We have some slight but important differences in the objects. Although this could be solved, it had to wait for a new major release.
    More importantly, we have more than 2000 users. If we roll out new functions, we would have to train them all at once, which is impossible.

    As I understand OMA, the rollout process is still manual. We need something that steps through a list of databases, connects to them, imports objects, handles conflicts in a predefined way and runs data conversion jobs with different parameters depending on the actual company.
    If it is not possible for 2009 R2, is there somthing similar out there for NAV 2016 or 2017?
  • Juhl
    Juhl Member Posts: 724
    Newer NAVs have powershell, that can do alot
    Follow me on my blog juhl.blog
  • ara3n
    ara3n Member Posts: 9,258
    LS Retail uses DD that replicates objects to all store. you can use that to replicate objects to multiple databases.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • AK
    AK Member Posts: 226
    What's "DD"? LS Retail doesn't seem to have a product named like that. Could you please elaborate?
  • geordie
    geordie Member Posts: 655
    Here some info about DD: http://www.bedege.se/images/Net/ls_data_director.pdf
    * Daniele Rebussi * | * Rebu NAV Diary *
  • AK
    AK Member Posts: 226
    Thanks!
  • kriki
    kriki Member, Moderator Posts: 9,121
    With version 3.01 I implemented replication completely in NAV. It could replicate data and also objects. And I was using NAS to do it in background.
    It exported table Object as text and also the BLOB in it which is the fob (in a different format).
    The receiving NAS picked it up and created record/updated the record and also imported the BLOB in the object table. After finishing this, it crashed itself. Then the Windows services restarted the NAS again with the new objects.

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • AK
    AK Member Posts: 226
    I'm working on a similar solution, but I also have to take care of the Object Metadata table (web services use it). So far it is pretty simple to code, the hard part is to make sure to deliver the right objects.
    Did you always import all objects? That is something I have to avoid.

Categories