<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>Ooops
sorry that is NOT what I am suggesting. Keep the classic FE/BE design, but put a
replica on each local PC and put the synchronizer on some box that is guaranteed
to be up 99% of the time. The latter can be the database server or any other
box. In my case I chose my development box, since I never shut it
off.</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2>So:</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>the
main replica (let's call it the office replica) lives where your current BE
lives.</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>a
replica exists on every PC in the branch.</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>the
master replica lives on your development box.</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>you
also have another replica on your box.</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>All
but the master are managed replicas (i.e. the synchronizer does
everything).</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>This
leaves you free to monkey with the master, to change table structures etc., to
write new code against the master and test until you're satisfied. Once you're
ready to roll out a new version of the BE, just synchronize with your local
replica, and next interval the synchronizer will propagate the changes to every
other replica. You don't even have to bring the system down to achieve
this.</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>To add
new branch offices (assuming a WAN or VPN), place a synchroizer on each branch's
file server and have it synchronize the local replicas. Have the HQ synchronizer
manage the branch replicas. </FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff size=2>Drop
boxes are necessary only for indirect (FTP or internet) replication, but
unnecessary for direct replication.</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2>HTH,</FONT></SPAN></DIV>
<DIV><SPAN class=052585816-13052003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>John
Skolits<BR><B>Sent:</B> May 13, 2003 10:14 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Replication
Manager or Briefcase<BR><BR></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>So
if I understand this, you suggest foregoing the FE/BE design, place everything
in one DB and use replication? HMMM interesting.</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>But,
if I have 5 of 7 users on a local network, I would want their data refreshes
to be immediate on the data tables. The remote users won't care if they
refresh only periodically.</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>I
would think that in this scenario, I would prefer to have a FE/BE design
on the local network with the one shared BE being a replica. On the remotes, I
would also want FE/BE design but all their individual BEs be separate
replicas. </FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>But,
now I'm mixing a shared BE and remote replica BEs. Is this a bad
idea?</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>In
addition, I like the idea of one replica on a local server
(sub-hub) managed by a synchronizer and then synchronized with the
main hub replica. </FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>But,
I thought each replica on the satellite PCs had to have a drop box. If that's
so, don't you have to install RepMnger on each PC have to have the drop
boxes?</FONT></SPAN><SPAN class=121305813-13052003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff size=2>Gee,
a lot to learn.</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2>John</FONT></SPAN></DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=121305813-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Arial
size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>