Post reply

Merge and transactional replication on same database

  • March 1, 2006 at 4:52 am

    #90616

    Hi,

    I want to replicate some table one-way like setup tables,and some tables on both ways like transaction tables. How can I don it on same database.

  • March 1, 2006 at 6:37 am

    #623930

    You just setup two different publications, 1 for each and select the objects you want in each.

  • March 2, 2006 at 7:23 am

    #624295

    I would suggest that if there aren't very many tables that are "one-way", it may be simpler (and easier to maintain) to use merge replication exclusively.

    Just don't update the one-way tables at the subscriber.  You can either design it that way or prevent it using data access security.

    jg

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply