• steve.roberts 86619 - Wednesday, June 20, 2018 8:41 AM

    Hi,

    My plan so far was

    Drop article from replication
    Rename table to table_tmp
    I assume I need to rename this table on the subscribers as well
    Create new table
    Add it back into replication?

    I got a little more detailed in the steps I provided, but the concept is the same...
    Once you stop replication, you can rename the table on the subscriber, or you can drop it altogether, because you're going to end up sending the entire table's worth of data across the wire again anyway....

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)