<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — syncing one database to many]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=3772&amp;type=atom" />
	<updated>2013-01-19T01:26:28Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=3772</id>
		<entry>
			<title type="html"><![CDATA[Re: syncing one database to many]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=15132#p15132" />
			<content type="html"><![CDATA[<p>Try federated databases - first on databases on the same server.<br />Or just views on the item related tables form one &quot;main&quot; database (read/write fror items) in the other databases (read only).</p><p>In these methods, no &quot;synch&quot;ing will be needed.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2013-01-19T01:26:28Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=15132#p15132</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[syncing one database to many]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=15128#p15128" />
			<content type="html"><![CDATA[<p>Hello,</p><p>So with my current software I have not been able to consider &quot;alterations/modification out of the box is what you get.</p><p>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.</p><p>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.</p><p>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.</p><p>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?</p><p>Any way I have converted my wife&#039;s accounting from QB and I am trying to &quot;stress&quot; FA as best I can for my purposes and seems to be exactly what is needed for my purpose.</p><p>Thanks,<br />Bill</p>]]></content>
			<author>
				<name><![CDATA[whtemple1959]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=13877</uri>
			</author>
			<updated>2013-01-18T21:32:15Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=15128#p15128</id>
		</entry>
</feed>
