Post reply

Transaction Replication Issue

  • March 17, 2017 at 12:10 am

    #335741

    Hi 

    I've setup transaction replication between SQL Server 2008 R2 (Publisher) and SQL Server 2012 (Subscriber). 

    Only 1 table is having issues so I just focused on this table and chose it as an Article. 

    Although I did not filter any columns, all the rows have been replicated but only 1 column was not replicated. So I'm still thinking why, even though the rows are in-sync, only 1 column is empty at the subscriber side. I checked the publisher and that column there are values in them. the column is an integer column. 

    Any thoughts on this?

    Thank you.

    Best Regards,

  • March 17, 2017 at 1:21 am

    #1933695

    Hi,
    is the missing column  just simple integer, or maybe  calculated from other columns ?
    I think for the replication, there is a difference, if the coloumn is just integer or calculated.
    Best regards,
    Andreas

  • March 18, 2017 at 10:26 am

    #1933863

    Hi Andreas,

    It is not a computed column. I will investigate further what is going on at the Publisher side.

    thank you for your reply,

    Best Regards,
    Ricky

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

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