Create A Replica Partner List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yerbmeld - 14 Jul 2006 17:48 GMT

Greetings,

I have a split db that the back end db is replicated. I have a form
that the users open when they need to synch with the replica hub.
Occassionally, the users will be on the road and need to synch with
each other. What table and fields would I need to query to build a list
of replica partners similar to the list that appears when you select
Syncronize Now from the Tools | Replication menu?

Reply to this Message

David W. Fenton - 15 Jul 2006 02:06 GMT

> I have a split db that the back end db is replicated. I have a
> form that the users open when they need to synch with the replica
[quoted text clipped - 3 lines]
> appears when you select Syncronize Now from the Tools |
> Replication menu?

MSysReplicas has the replicas in it.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

yerbmeld - 15 Jul 2006 18:32 GMT

Okay, MSysReplicas is the table. Now how about answering the other
portion of my question concerning the fields I need to be concerned
with. I can review the MSysReplicas table and see that not all the
replicas in the table appear in the list provided when I click
Synchronize now.

Darrell

> > I have a split db that the back end db is replicated. I have a
> > form that the users open when they need to synch with the replica
[quoted text clipped - 9 lines]
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

David W. Fenton - 16 Jul 2006 02:17 GMT

> Okay, MSysReplicas is the table. Now how about answering the other
> portion of my question concerning the fields I need to be
> concerned with. I can review the MSysReplicas table and see that
> not all the replicas in the table appear in the list provided when
> I click Synchronize now.

Don't be so demanding -- you have no right to an answer to the
question.

Check the REMOVED column. I don't know exactly what the numbers
mean, but I think any replica with a null or0 value will show up in
the list.

Also, there's the question of accessibility. You don't want to
display replicas that are inaccessible to the replica you're
synching from. I don't know exactly how you determine this for
yourself, but for a laptop user, I would only allow synchronization
with the hub on the server in the main office. I can't see any
utility in suggesting a synch with another laptop user, so would
filter all of those out of the list.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message