How to merge distributed database

tofay

Can any body tell me how to merge two or more database of the same structure, taking into consideration the Entry tables and the entry numbers

kriki

If they have the same objects, you can just take a backup of the companies and restore them in 1 DB.
IMPORTANT:you have to check the tables with property "DataPerCompany"=FALSE. It is possible you have to write a dataport to export/import them in case some of the data exists in 1 DB but not in the others.

ara3n

My guess, but he wants to merge two databases into the same company?

kine

Please, do not try it if you are not Navision SuperGURU (if you want to merge the data from two companies into one). If you just needs consolidate the companies, use the standard module. If you need to merge two companies because they merged together, select one company as base and add the initial entries from second company... (like when starting new company - add the customer/vendor/item cards, import and post the Balance for Accounts, customers, vendors etc...)

tofay

I've tried all the hints, but still the problem persist, however i dont want to re-post into the central database, because i'm using a replicating tool called MBS Replicator to replicate the remote database to a central database.
Can we consider this a limitation on the part of Navision?

bbrown

Can you provide more details on what you are trying to do? and also why?

Also which database are you using?

Can we consider this a limitation on the part of Navision?

Why would you consider system integrity and maintaining a valid audit trail a limitation? [-(

Alex_Chow

tofay wrote:

I've tried all the hints, but still the problem persist, however i dont want to re-post into the central database, because i'm using a replicating tool called MBS Replicator to replicate the remote database to a central database.
Can we consider this a limitation on the part of Navision?

To keep the integrity of the system, you almost have to do what you don't want. That is, to re-post these transactions into your master database.

Is your merging a one time deal? Or is it done periodically?
Is it for management report purpose? Or part of your business process?

DenSter

What is this tool 'MBS Replicator'?

tofay

what i'm trying to do is to have a central database that contain entries from several remote database into the same company, the remote database and the central database belong to the same company, so we need to see on the central database the complete status of the company, so i'm using a third party navision tool named MBS Replicator to replicate information from the remote database to the central database where we intend to capture the complete information of the company.
This solution is for both management report purpose and business process purpose and the replication will be done regularly to keep the central database updated.

Luc_VanDyck

DenSter wrote:

What is this tool 'MBS Replicator'?

I presume the tool from DataBackbone: http://www.databackbone.com/domsite/bac ... endocument

tofay

yes, MBS Replicator is from databackbone
http://www.databackbone.com/domsite/bac ... endocument

ara3n

Does this addon works? how is it compared to LS retail replicator tool called Data Director? DD is powerfull tool, but not userfriendly and no documentation.