By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,321 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,321 IT Pros & Developers. It's quick & easy.

Replication: Transactional: Multi Publications, One Subscriber.

P: n/a
Greetings All, I was hoping that a replication sage might be able to
answer a question for me.

I want to have one subscriber subscribing to N publishers. I
essentially have a company that has a main headquarters and three
satellite offices. I want each of the satellite offices to push their
data up to the master database. From what I have read it seems like
this should not be a problem. Some questions that come to mind are:

1.) Does the master need to be read only or can it be configured to be
updateable as well?
2.) Can the distribution agent on all the publishers be set to
continuously distribute or should it be staggered so as not to cause a
problem when another distribution agent is running?
3.) If the distribution is set to "delay distribution" will this cause
changes on the subscriber to be pushed out to the publishers?
In this database guid's are used as pk's so the issue of pk collisions
is not a problem.

I hope that this question is not too vague. My experience thus far
with replication has been simple one way transactional and simple
merge replication.

Regards, Louis Frolio
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"Louis Frolio" <fr*****@yahoo.com> wrote in message
news:94**************************@posting.google.c om...
Greetings All, I was hoping that a replication sage might be able to
answer a question for me.

I want to have one subscriber subscribing to N publishers. I
essentially have a company that has a main headquarters and three
satellite offices. I want each of the satellite offices to push their
data up to the master database. From what I have read it seems like
this should not be a problem. Some questions that come to mind are:

1.) Does the master need to be read only or can it be configured to be
updateable as well?
2.) Can the distribution agent on all the publishers be set to
continuously distribute or should it be staggered so as not to cause a
problem when another distribution agent is running?
3.) If the distribution is set to "delay distribution" will this cause
changes on the subscriber to be pushed out to the publishers?
In this database guid's are used as pk's so the issue of pk collisions
is not a problem.

I hope that this question is not too vague. My experience thus far
with replication has been simple one way transactional and simple
merge replication.

Regards, Louis Frolio


You might want to post this in microsoft.public.sqlserver.replication, where
there are probably more replication sages than in this newsgroup.

Simon
Jul 20 '05 #2

P: n/a
fr*****@yahoo.com (Louis Frolio) wrote in message news:<94**************************@posting.google. com>...
Greetings All, I was hoping that a replication sage might be able to
answer a question for me.

I want to have one subscriber subscribing to N publishers. I
essentially have a company that has a main headquarters and three
satellite offices. I want each of the satellite offices to push their
data up to the master database. From what I have read it seems like
this should not be a problem. Some questions that come to mind are:

1.) Does the master need to be read only or can it be configured to be
updateable as well?
2.) Can the distribution agent on all the publishers be set to
continuously distribute or should it be staggered so as not to cause a
problem when another distribution agent is running?
3.) If the distribution is set to "delay distribution" will this cause
changes on the subscriber to be pushed out to the publishers?
In this database guid's are used as pk's so the issue of pk collisions
is not a problem.

I hope that this question is not too vague. My experience thus far
with replication has been simple one way transactional and simple
merge replication.

Regards, Louis Frolio

Q #1 1.) Does the master need to be read only or can it be configured to be
updateable as well?
A. The subscriber database can be updated by users on that end, it
does not need to be read only.

Q #2 continuously distribute or should it be staggered so as not to cause a
problem when another distribution agent is running?
A. It can be done either way without issue.

Q #3 3.) If the distribution is set to "delay distribution" will this cause
changes on the subscriber to be pushed out to the publishers?


A. No.
All, I have answered my own questions since I posted this missive.
Jul 20 '05 #3

P: n/a
"Simon Hayes" <sq*@hayes.ch> wrote in message news:<41********@news.bluewin.ch>...
"Louis Frolio" <fr*****@yahoo.com> wrote in message
news:94**************************@posting.google.c om...
Greetings All, I was hoping that a replication sage might be able to
answer a question for me.

I want to have one subscriber subscribing to N publishers. I
essentially have a company that has a main headquarters and three
satellite offices. I want each of the satellite offices to push their
data up to the master database. From what I have read it seems like
this should not be a problem. Some questions that come to mind are:

1.) Does the master need to be read only or can it be configured to be
updateable as well?
2.) Can the distribution agent on all the publishers be set to
continuously distribute or should it be staggered so as not to cause a
problem when another distribution agent is running?
3.) If the distribution is set to "delay distribution" will this cause
changes on the subscriber to be pushed out to the publishers?
In this database guid's are used as pk's so the issue of pk collisions
is not a problem.

I hope that this question is not too vague. My experience thus far
with replication has been simple one way transactional and simple
merge replication.

Regards, Louis Frolio


You might want to post this in microsoft.public.sqlserver.replication, where
there are probably more replication sages than in this newsgroup.

Simon


Simon, thanks I did not realize that that group existed.

L
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.