<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — syncing one database to many]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=3772</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=3772&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in syncing one database to many.]]></description>
		<lastBuildDate>Sat, 19 Jan 2013 01:26:28 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: syncing one database to many]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=15132#p15132</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sat, 19 Jan 2013 01:26:28 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=15132#p15132</guid>
		</item>
		<item>
			<title><![CDATA[syncing one database to many]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=15128#p15128</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (whtemple1959)]]></author>
			<pubDate>Fri, 18 Jan 2013 21:32:15 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=15128#p15128</guid>
		</item>
	</channel>
</rss>
