Home Forums SQL Server 2008 SQL Server 2008 - General SQL Transactional Replication RE: SQL Transactional Replication

  • June 20, 2018 at 11:02 am

    #1994685

    sgmunson - Wednesday, June 20, 2018 9:12 AM

    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....

    If someone only wants to generate the snapshot of just the added article, it really would need more detail. But it depends on the publication.

    But (I should have added this earlier for the poster) if they want to just generate a snapshot for only the added article, that's where the add article needs to be done with force invalidate snapshot to true/1. And then the publication has to have immediate sync and allow anonymous set to false/0

    Sue