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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merge Replication Proplem

Status
Not open for further replies.

magdyk

Programmer
May 7, 2001
12
0
0
EG
in a merge replication

there is a column in a table on the publisher i don't want to replicate it
but i want it to be in the subscriber database

ex:
publisher Table
Field1 (want to replicate )
Field2 (Don't want to replicate )
Field3 (want to replicate )

in the publication i excluded Field2 from the publication
but when the snapshot agent applies the snapshot schema it doesn't take the Field2 with it

Subscriber Table
Field1 (want to replicate )
Field3 (want to replicate )
as u can see there is no Field2

i want field to to be in the subscriber database and not in the publication (i don't want to replicate field2)

please help
thanks



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top