Post reply

Replication - not all columns are updating

  • April 20, 2021 at 1:37 am

    #3873321

    I've set up replication but I'm having difficulties in my testing. I've changed 3 fields in the publication database, but only 1 of those 3 fields updates in the subscriber database. I've verified that all 3 fields are in the article. I've looked at the replication sproc and it looks fine for _UPD and _INS (just in case my 3rd party calling program deletes and adds).  Other individual fields that I've added in other tables are replicating fine. This is the first case where 3 fields are updated simultaneously.

    I'm not sure where to look to diagnose this.

    Thanks in advance.

  • April 20, 2021 at 2:20 am

    #3873324

    Never mind... I figured it out. We're modifying the update script and altering it. I missed changing the bitmap size to accommodate extra fields when the table expanded.

  • May 18, 2021 at 8:02 am

    This was removed by the editor as SPAM

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

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