Post reply

Changing replication publication name

  • November 19, 2013 at 2:17 pm

    #301553

    Is it possible to change replication publication name without dropping the replication and rebuilding it?

  • November 19, 2013 at 2:31 pm

    #1667591

    No

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • November 20, 2013 at 1:05 am

    #1667693

    The only way is to drop and rebuild the publication.

    If you can restrict access to the publisher and subscribers, you can drop, rebuild and add the subscribers as @sync_type='none' or @sync_type='replication support only'.

    This would quickly rebuild replication without the need to initialize the subscribers (backup or snapshot).

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply