Basic replication question

[jsteph]

Hi all,
We have a hosted payroll system, wherein the vendor replicates data to our local sql-2000 database.

My question is, if I make a change to our local copy, will it get overwritten by the host system if the original host record does not undergo any future edit?

I guess the question boils down to--does replication push *only* updates and additions from the host system, or (and I know this would be a logistically huge challenge especially for big tables) does it somehow detect changes on the local replicated system and 'fix' them?
Thanks,
--Jim

 

[mrdenny]

Your changed value will be left alone so long as the record isn't changed on the source system. Replication only pushes changes, it doesn't look for changed records on the subscriber to overwrite them.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog