question

marqueluis avatar image
marqueluis asked

Changing Publisher and Subscriber Roles

I have Publisher Server P and Subscriber Server S. I want to change server P to become the subscriber and Server S to become the publisher. how do i change the role for each server without having to create a new Publication/subscription ?
publisher
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
sqlaj 1 avatar image
sqlaj 1 answered
You can't make that change without dropping replication and configuring the Server S for replication.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.