Source columns for publications

By default when you create publications, changes to all columns that are in the source table are published. However, you can publish a subset of the columns if you do not want to make all of the columns that are in the source table available to the user application.

You might also want to publish a subset of the columns if the user application for a publication does not support all of the data types that are defined for the source table.

To publish a subset of the columns, select only the source columns that you want to be published to the user application. If you are creating a single publication, then the Create Publications wizard in the Replication Center gives you options for how to publish a subset of the columns from the source table. If you are creating multiple publications at one time, then, on the Review page of the Create Publications wizard, select the individual publication for which you want to publish only a subset of the columns, and then edit the properties for that publication.

Important for LOB columns: If you select columns that contain LOB data types for a publication, make sure that the source table enforces at least one unique database constraint (for example, a unique index or primary key). You do not need to select the columns that make up this uniqueness property for the publication.