SQL Server Performance

SS2K5 dynamic replication

Discussion in 'SQL Server 2005 Replication' started by Makko, Dec 13, 2007.

  1. Makko New Member

    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 andcantity values ... the id,name and global columns I cant modify
    If Global = FALSE i can replicate back to dbMaster.aTable whole rowcreated in dbSlave.aTable and Global will be FALSE too indbMaster.aTable

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

    thank you
  2. satya Moderator

    Welcome to the forum!
    Do you have repliation setup already or thinking to go towards replication for this type of conditions?

Share This Page