| Description | I'm using the sample envoronment (Store - Corp). On Corp: create table blobs (id numeric primary key identity, data varbinary(max)) insert into sym_trigger (trigger_id,source_table_name,channel_id,last_update_time,create_time) values('blobs','blobs','item',current_timestamp,current_timestamp); insert into sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) values('blobs','corp_store_identity', 200, current_timestamp, current_timestamp); insert into sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) values('blobs','store_corp_identity', 200, current_timestamp, current_timestamp); 1. insert into blobs(data) values (convert(varbinary(max), 'XXX')) OK - is published to store update blobs set data = (convert(varbinary(max), 'oooo')) where id = 1 Not OK: No publishing to store delete blobs where id=1 OK - is published to store |
|---|