Post reply

Partition Swapping in Replicated Tables

  • June 6, 2008 at 10:37 am

    #187722

    Hello, SQL gurus! I'm attempting to swap out partitions in a very large (~1 billion rows), replicated, horizontally-partitioned table. From what I can tell, this is not supported in 2005, so I'm looking for a work-around. Is there any way to disable to a replication subscription to allow the meta-data change without deleting / recreating the subscription?

    I greatly appreciate any help or links to resources on this topic! 🙂

    Kind Regards,

    Michelle

    Regards,

    Michelle Ufford
    SQLFool.com - Adventures in SQL Tuning

  • June 6, 2008 at 11:28 am

    #825613

    If you are planning to do this on the Subscriber then nothing prevents you from doing it. Now if you are talking about changing the Publisher, I believe you ( and I) are out of luck 🙁


    * Noel

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

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