Change Local Subscription to Global

Does anyone know how to change a local pull subscription in merge
replication to a global subscription? I tried using
"sp_changemergesubscription" which is executed at the publisher according to
BOL and set a priority other than zero, but I get an error that says a local
subscription cannot be changed to a global subscription.
Is there something I need to execute at the subscriber?
Thanks.
Bill
Hi Bill,
From your descriptions, I understood that you would like to change local
subscription to global subscription. Have I understood you? Correct me if I
was wrong.
Based on my knowledge, unfortunately, we are not able to perform such
changes. We could select local subscription or gloabl subscription when
creating the subscription, however as the error message shows, we cannot
modify it. If you want to do so, you will have to delete the subscription
and then recreate it.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you, Michael. I suspected this was the case, but it is good to get it
verified.
I am doing some testing on setting up an alternate synchronization partner,
and having some trouble with it, so I'll likely have another post on that
issue soon.
Thanks again.
Bill
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:VAcGvVSJFHA.132@.TK2MSFTNGXA02.phx.gbl...
> Hi Bill,
> From your descriptions, I understood that you would like to change local
> subscription to global subscription. Have I understood you? Correct me if
> I
> was wrong.
> Based on my knowledge, unfortunately, we are not able to perform such
> changes. We could select local subscription or gloabl subscription when
> creating the subscription, however as the error message shows, we cannot
> modify it. If you want to do so, you will have to delete the subscription
> and then recreate it.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hi Bill,
Thank you for the kindly separate the issue. I have taken that one and am
doing some research on it, I will update you as soon as possible when I
find anything useful to add.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.