Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The way Replication Server replicates...

Status
Not open for further replies.

aifong

Programmer
Jan 15, 2002
4
MY
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!!
 
hello,

think of replication as a magazine subscription... the replicated database will only get data as described by your subscription... if you have a rep server manual try using subsriptions...

hth,
q.
 
If you update a single row in the MAIN, all the columns for that row will be updated on the TARGET, until you configure the replication definition on that table. You can use "replicate minimal columns" option with the "create replication definition..." syntax to configure it on MAIN.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top