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
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