<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="http://syndication.webwiz.co.uk/rss_namespace/">
 <channel>
  <title>DevForce Community Forum : Working with a Distributed Database</title>
  <link>http://www.ideablade.com/forum/</link>
  <description>This is an XML content feed of; DevForce Community Forum : DevForce Classic : Working with a Distributed Database</description>
  <pubDate>Tue, 12 May 2026 23:27:53 -700</pubDate>
  <lastBuildDate>Wed, 06 Jun 2007 15:48:08 -700</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 9.69</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>www.ideablade.com/forum/RSS_post_feed.asp?TID=68</WebWizForums:feedURL>
  <image>
   <title>DevForce Community Forum</title>
   <url>http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png</url>
   <link>http://www.ideablade.com/forum/</link>
  </image>
  <item>
   <title>Working with a Distributed Database :  Answer: It is true that most...</title>
   <link>http://www.ideablade.com/forum/forum_posts.asp?TID=68&amp;PID=142#142</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.ideablade.com/forum/member_profile.asp?PF=21" rel="nofollow">IdeaBlade</a><br /><strong>Subject:</strong> 68<br /><strong>Posted:</strong> 06-Jun-2007 at 3:48pm<br /><br /><DIV =Secti&#111;n1><P =Questi&#111;n style="MARGIN: 0in 0in 0pt"><strong><EM><FONT face="Times New Roman" size=3>Answer:</FONT></EM></strong></P><P =Ms&#111;normal style="MARGIN: 8pt 0in 0pt"><FONT face="Times New Roman" size=2>It is true that most of our documentation describes building applications using a centralized database, but one of the strengths of our product is the ability to&nbsp;provide disconnected support.&nbsp; When working while disconnected, there are two different strategies.&nbsp; The first (and simplest strategy) allows objects in the persistence cache to be stored and loaded into and from files in the file system.&nbsp; These files can be encrypted if desired.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>You can see an example of this strategy in our tutorials.&nbsp; </FONT></P><P =Ms&#111;normal style="MARGIN: 8pt 0in 0pt"><FONT face="Times New Roman" size=2>This strategy works fine in many situations, but in other situations where the application is more complex and the database is quite large, we recommend the use of a local database such as SQL Server Express.&nbsp; We do have customers who started out providing disconnected support to their customers through the simple local file mechanism, and then moved to a distributed database design.</FONT></P><P =Ms&#111;normal style="MARGIN: 8pt 0in 0pt"><FONT face="Times New Roman" size=2>&nbsp;A distributed database design requires support for a number of features.&nbsp; One of these features is good support for concurrency conflict resolution.&nbsp; We provide excellent support in this area, and I would encourage you to look at&nbsp;our tutorial on this subject.&nbsp;&nbsp;&nbsp; We do not yet have a service broker that allows SQL Express clients to communicate with&nbsp;a main SQL Server, but we'd be happy to talk to you about this requirement.&nbsp; There is nothing in our architecture that prohibits&nbsp;the use of such a broker, and, in fact,&nbsp;it is a crucial component of our long-term plan to provide ever better support for disconnected use.</FONT></P></DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-: EN-US; mso-fareast-: EN-US; mso-bidi-: AR-SA"><BR style="PAGE-BREAK-BEFORE: always; mso-break-: secti&#111;n-break" clear=all></SPAN><P =Ms&#111;normal style="MARGIN: 8pt 0in 0pt"><?:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><FONT face="Times New Roman" size=2>&nbsp;</FONT></o:p></P>]]>
   </description>
   <pubDate>Wed, 06 Jun 2007 15:48:08 -700</pubDate>
   <guid isPermaLink="true">http://www.ideablade.com/forum/forum_posts.asp?TID=68&amp;PID=142#142</guid>
  </item> 
  <item>
   <title>Working with a Distributed Database : Question:  There are many aspects...</title>
   <link>http://www.ideablade.com/forum/forum_posts.asp?TID=68&amp;PID=141#141</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.ideablade.com/forum/member_profile.asp?PF=20" rel="nofollow">Customer</a><br /><strong>Subject:</strong> 68<br /><strong>Posted:</strong> 06-Jun-2007 at 3:47pm<br /><br /><P =Questi&#111;n style="MARGIN: 0in 0in 0pt"><strong><EM><FONT face="Times New Roman" size=3>Question: </FONT></EM></strong></P><P =Ms&#111;normal style="MARGIN: 8pt 0in 0pt"><FONT face="Times New Roman" size=2>There are many aspects to your product that are appealing; however, it appears as though there is a fixed architecture based on a centralized database.</FONT></P><P =Ms&#111;normal style="MARGIN: 8pt 0in 0pt"><FONT face="Times New Roman" size=2>Is it possible to have a distributed database architecture where individual clients have their own specific data and communicate with a central database for updates?</FONT></P><P =Ms&#111;normal style="MARGIN: 8pt 0in 0pt"><SPAN style="mso-bidi-font-size: 10.0pt"><FONT size=2><FONT face="Times New Roman">SQL Server is ideally suited for this, with distributed, royalty-free SQL Express clients communicating via a service broker to a centralized main SQL Server. However, from my quick assessment this capability does not appear to be supported within your framework.<?:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></SPAN></P>]]>
   </description>
   <pubDate>Wed, 06 Jun 2007 15:47:15 -700</pubDate>
   <guid isPermaLink="true">http://www.ideablade.com/forum/forum_posts.asp?TID=68&amp;PID=141#141</guid>
  </item> 
 </channel>
</rss>