Consolidation of data from many DB

(0) Share

Report

Posted on by Gabsi Mohamed

819

Dear All,

I have 7 db in Africa, 3 in Dynamics NAV 2013 R2, and the others in Navision 5.(All data in english).
i want to create new DB to consolidate DATA (Sales, Finance..).
what's the best method, technology to do that.

THANKS

*This post is locked for comments

All responses (3)

Answers (0)

Gabsi Mohamed 819 on at

Like (0)

Report

RE: Consolidation of data from many DB

Hi Suresh,

ok, we are planned to convert all DB to NAV 2013 R2.

But how i can consolidate all data of NAV 2013 R2 in one BD.

i need this only for analytic and BI.

THANKS
mmv 11,467 on at

Like (0)

Report

RE: Consolidation of data from many DB

Hi,

As mentioned by Suresh, you need to upgrade your NAV 5 database to NAV 2013 R2 if you are planning to have everything in a single database.
Suggested answer

Suresh Kulla 44,656 on at

Like (0)

Report

RE: Consolidation of data from many DB

Are you planning to create a new database with only one single company with all the data ? If so first you need to convert Navision 5 database into NAV 2013 R2, because there are many changes in the table structure and objects between Navision 5 and NAV 2013 R2

So first you need to perform an upgrade from Navision 5 to NAV 2013 R2.