|
-
Dec 13th, 2007, 04:17 PM
#1
Thread Starter
Member
Sql Server Dynamic Replication
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|