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.
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.
17 People are following this question.
