Post reply

SS2K5 dynamic replication

  • December 13, 2007 at 2:26 pm

    #182018

    Hi

    I have 'aTable' table on both dbMaster and dbSlave databases... The structure of aTable is

    id(int),name(vchar),price(int)cantity(int),global(bit)

    If Global = TRUE i can replicate the whole row from dbMaster.aTable to dbSlave.aTable

    If Global = FALSE i cant replicate any row from dbMaster.aTable to dbSlave.aTable

    This I do it using a filter on global column at the sbMaster Publisher

    My problem is at dbSlave side

    If Global = TRUE i can replicate back to dbMaster.aTable only price and cantity values ... the id,name and global columns I cant modify

    If Global = FALSE i can replicate back to dbMaster.aTable whole row created in dbSlave.aTable and Global will be FALSE too in dbMaster.aTable

    hope someone understands what i'm trying to say here and give me an advice

    thank you

  • December 16, 2007 at 5:37 am

    #760580

    Is that a transactional replication with updatable subscriptions or a merge replication?

    -- Erik http://blog.rollback.hu

  • December 17, 2007 at 2:23 pm

    #760832

    merge

  • December 18, 2007 at 3:39 pm

    #761252

    I think you will be better off programing your custom logic in stored procedures!!!


    * Noel

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

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