Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replication Newbie
Message
From
22/03/2005 10:00:44
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Replication
Title:
Replication Newbie
Miscellaneous
Thread ID:
00998078
Message ID:
00998078
Views:
68
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
Roses are #FF0000 Violets are #0000FF all my base are belong to you
Next
Reply
Map
View

Click here to load this message in the networking platform