Hi all
I'm a real newbie so i'm wondering if anyone knows for sure how Replication Server replicates its data. I've setup a basic copy model replication on my test environment here; where MAIN is the primary database and TARGET is the replicate database. But the design is such that a table in the TARGET database has an identity column whereby data is inserted in TARGET, copied over to MAIN by another program and then subsequently, I use Replication Server to replicate these updates back to MAIN. The problem is... I update one field in the table in MAIN but the query that executes updates every single field in TARGET including the identity field, causing it to fail.
Basically I just need to know if when I update a single column in a row in MAIN, will only that single column be updated in TARGET or will all the columns on that row be updated? Or is this something that can be configured in Rep Server?
Any help is appreciated!!
I'm a real newbie so i'm wondering if anyone knows for sure how Replication Server replicates its data. I've setup a basic copy model replication on my test environment here; where MAIN is the primary database and TARGET is the replicate database. But the design is such that a table in the TARGET database has an identity column whereby data is inserted in TARGET, copied over to MAIN by another program and then subsequently, I use Replication Server to replicate these updates back to MAIN. The problem is... I update one field in the table in MAIN but the query that executes updates every single field in TARGET including the identity field, causing it to fail.
Basically I just need to know if when I update a single column in a row in MAIN, will only that single column be updated in TARGET or will all the columns on that row be updated? Or is this something that can be configured in Rep Server?
Any help is appreciated!!