Distribution of FOBs to several databases

AK

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.

Juhl

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....

tomcollins

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

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

Newer NAVs have powershell, that can do alot

ara3n

LS Retail uses DD that replicates objects to all store. you can use that to replicate objects to multiple databases.

AK

What's "DD"? LS Retail doesn't seem to have a product named like that. Could you please elaborate?

geordie

Here some info about DD: http://www.bedege.se/images/Net/ls_data_director.pdf

AK

Thanks!

kriki

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.

AK

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.