question

Jun avatar image
Jun asked

How can prevent some fields from replicating in SQL Server?

I have a table replicated as a transactional publisher. All its schema and data are replicated. But I need to exclude 1 field of this table from replicating but yet maintaining the schema intact. It is possible? When I uncheck from the article properties it also deletes the entire field to the subscriber. But i still need this column in the subscriber.
replicationtransactional-replicationpublisher
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
happycat59 avatar image
happycat59 answered
Yes this is possible. When you create the article, change the article properties so that the "Action if name in use" is anything except "Drop existing object and create a new one". Exactly which one depends on your needs. You now need to create the table either explicitly (e.g. script the table and run that script on the subscriber using management studio) or by creating scripts for replication to apply. It may be simpler to create the table using SSMS. Make sure that the column accepts NULLs.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks! really appreciate. :-)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.