CODEWITHSUNDEEP
sqlsql-server-2012database-replicationtransactional-replication
Rajesh Bhat
Rajesh Bhat

Reputation: 811

Transaction replication not replicating one column value

One column of type varbinary(200) is not getting replicated to destination table from source table. I have tried updating the column value in main table again but still it is not getting replicated to destination table. Am not seeing any error in replication job and tried running snapshot too. But still no luck. What could be wrong?? Using SQL server 2012.

Replication script for this table: exec sp_addarticle @publication = N'CWT1200UAT', @article = N'usr_mast', @source_owner = N'dbo', @source_object = N'usr_mast', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000803509F, @identityrangemanagementoption = N'none', @destination_table = N'usr_mast', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dbousr_mast]', @del_cmd = N'CALL [sp_MSdel_dbousr_mast]', @upd_cmd = N'SCALL [sp_MSupd_dbousr_mast]'

Upvotes: 0

Views: 869

Answers (1)

Rajesh Bhat
Rajesh Bhat

Reputation: 811

The issue got resolved after performing following actions: 1. Remove the table which has the issue from replication. 2. Run the snapshot replication and wait for completion. 3. Add back the table into replication. 4. Run the snapshot replication and wait for completion.

Upvotes: 1

Related Questions