Hi guys,
Two branched or our currently connected through VPN 512kbps XDsl line. now what would be the best possible replication use . where Branch A contains live and we want to sycn it to branch B which branch B requires only for view and reporting. I use Snapshot replication
but it seem an error occur when subcribing. Ive notice dat theres an erron creating and delete existing structure of Branch B every time I Sync. It seem that there is a Referencial Integrity error.
my question is ,is replication works like this, when i change structure in Branch A, does it also change structure on branch B? or do i need to drop or Contraints before Sync? what primary Key field it requires? currenty i used only Int as my primay key
tns