Groups | Blog | Home
all groups > sql server replication > may 2005 >

sql server replication : merge to different column name


Rob Blij
5/6/2005 12:00:00 AM
I know it is possible to have one article merge to a different column name:

Is it possible to have different table names and different column names
merging?

One DB will pull from the other but will not merge back

Thanks,
Rob

Hilary Cotter
5/7/2005 10:35:52 AM
AFAIK - no this is not possible without considerable hacking. When the merge
agent applies changes on the publisher it uses insert, update and delete
statements, when it applies them on the subscriber it used procs.

You would have to modify these procs to do this.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

AddThis Social Bookmark Button