Re: Replication Manager - Direct vs. Indirect Synchronization
- From: "Tony" <|toxendine@xxxxxxxxxxxxxx|>
- Date: Tue, 14 Apr 2009 19:14:39 -0500
Well, I answered one of my questions with further research. I see that the
Jet Synchronizer needs to be running on the server to be able to handle
requests from clients for syncs. With that running, the issue that I'm
running into is that no .msg files are being put in the dropboxes. They are
shared out, everyone has full rights, and the reg keys on the server and
client show the correct dropbox paths. The code I'm using to attempt to
perform the sync is:
Private WithEvents moSync As Synchronizer
If moSync Is Nothing Then
Set moSync = New Synchronizer
End If
moSync.DatabaseName = strFromDatabase
moSync.Running = True
moSync.SynchIndirect strToDatabase, synchTypeReplImport
Where strFromDatabase and strToDatabase are passed in from a form. The
values being passed in are the UNC paths to the hub dB and client dB,
respectively. The code runs, but no .msg files are generated and nothing is
updated. Any ideas on what I might be missing?
Thanks,
Tony
"Tony" <|toxendine@xxxxxxxxxxxxxx|> wrote in message
news:uoQG1PUvJHA.1916@xxxxxxxxxxxxxxxxxxxxxxx
David,
Thanks for the offer of assistance. Based on the link you provided (yes,
we were talking about the same post), I've gotten as far as creating a hub
dB. I have a FE/BE where the BE is the design master with which the hub
will perform a direct, one way sync from the BE to the hub. So far, so
good. And, I've verified that my shares, paths, etc. are referenced in the
registry of my server (location of FE/BE & hub), and my client. I've
performed a direct sync between design master & hub and MSTranspAddress
(in the hub) shows the server's dropbox in FSAddress. At this point, I
have some questions:
- Step # 3a indicates that I need to add to the ManagedReplicas collection
the local replica. I did not explicitly do this with this round of trial
& error, but during my experimentation I did this earlier in the day. The
Jet Transporter reg key indicates that my hub is managed; is that
sufficient?
- Does the Jet Synchronizer always need to be running or if a client
machine requests a sync, will it launch (I suspect the former is true but
want to be sure)
- The instructions indicate that I copy the replica to my client, then
perform a direct sync. Does it matter from which dB (client or hub) that
I initiate the direct sync?
- What should I expect to see in MSysTranspAddress after I've performed
the direct syncs between clients & hub? Should I then see a second entry
with FSAddress value of my client's dropbox?
Thanks again for the help; I appreciate it.
Tony
"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns9BED9A22EB2CDf99a49ed1d0c49c5bbb2@xxxxxxxxxxxxxxxxx
"Tony" <|toxendine@xxxxxxxxxxxxxx|> wrote in news:ORagr9QvJHA.1304
@TK2MSFTNGP05.phx.gbl:
Up to this point I have a test environment whereparticular with
direct sync works, but am struggling a bit with indirect, in
setting up drop boxes, managed replica sets, etc. Not sure howthis is done
but will check Trigeminal. Also reviewing a thread I found onaccessmonster
where you helped out someone with indirect sync.
Just to clarify: I have never posted on AccessMonster. AccessMonster
is one of those sites that leaches off public Usenet postings by
sticking them in a web-based interface and selling advertisements. I
post direct to a news server using a news reader.
Thanks a million for thethis, I can
assistance. Even though I'm not where I want or need to be with
already see that it's going to be much more powerful and intuitivethan
Replication Manager.
Well, post with problems. I had problems, too, and eventually created
a little application that replicates the functionality of the ReplMan
setup wizard. It's all proprietary so I can't share it, but I can
certainly explain how I accomplished what it does. Basically it's an
implementation of all the points found in this post:
http://groups.google.com/group/microsoft.public.access.replication/ms
g/3b7167c1462b2d2f
That's probably the post you're referring to.
But do post back here with questions, as I'm happy to answer them
publicly so as to help others with the same problems
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.
- Follow-Ups:
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: David W. Fenton
- Re: Replication Manager - Direct vs. Indirect Synchronization
- References:
- Replication Manager - Direct vs. Indirect Synchronization
- From: Tony
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: David W. Fenton
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: Tony
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: David W. Fenton
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: David W. Fenton
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: Tony
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: David W. Fenton
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: Tony
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: David W. Fenton
- Re: Replication Manager - Direct vs. Indirect Synchronization
- From: Tony
- Replication Manager - Direct vs. Indirect Synchronization
- Prev by Date: Re: Replication Manager - Direct vs. Indirect Synchronization
- Next by Date: Re: Replication Manager - Direct vs. Indirect Synchronization
- Previous by thread: Re: Replication Manager - Direct vs. Indirect Synchronization
- Next by thread: Re: Replication Manager - Direct vs. Indirect Synchronization
- Index(es):
Relevant Pages
|
Loading