Topic: syncing one database to many

Hello,

So with my current software I have not been able to consider "alterations/modification out of the box is what you get.

I have been pounding away at trying to learn FA and understand mySQL for a few months now and have it pretty much under control and am ready to give FA a true test run.

I did a search and found a post about sharing a database between companies and while it was informative I only understood about a third of it and it did not really address my need.

I consult with several Independent Representatives of the same company and while I do want to keep their data separate they do utilize the same inventory list.

So is there a way to create a database of just the inventory ( items, cost, price, supplier, maybe GL accounting info) and then when there is an addition or deletion I could update all the company databases with like a sync command rather than editing each company by hand?

Any way I have converted my wife's accounting from QB and I am trying to "stress" FA as best I can for my purposes and seems to be exactly what is needed for my purpose.

Thanks,
Bill

Re: syncing one database to many

Try federated databases - first on databases on the same server.
Or just views on the item related tables form one "main" database (read/write fror items) in the other databases (read only).

In these methods, no "synch"ing will be needed.