• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Antony
#1 Posted : Tuesday, October 16, 2007 7:52:59 AM(UTC)
Antony

Rank: Member

Joined: 6/10/2004(UTC)
Posts: 260

Hi

I am trying to setup two stores that have the same content/products but thier own customers/orders. I plan to replicate the content/product tables and it appears the best way of doing this is 'Transactional publication with updatable subscriptions' (so its automatic).

However as the attachment shows this can't be done on some tables that do not have primary keys.

1) Does this mean you should not use 'Transactional publication with updatable subscriptions'?
2) What problems if any are likely if you add primary keys to these tables i.e. bvc_ProductXCategory so that you can then have 'Transactional publication with updatable subscriptions'

Thanks for any thoughts

Cheers
Antony attached the following image(s):
Replicate_BVC.jpg (214kb) downloaded 33 time(s).

You cannot view/download attachments. Try to login or register.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2025 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012