Operator Guide

10.4.1
- 10.5
- 10.4.0

Back Next

Topic Structure Updates

When you edit the structure of a topic with associated publications or subscriptions, it might affect the associated publications and subscriptions. Topic structure changes might also impact the data in the publication repository and sometimes cause data loss.

Based on the nature of the update, you might have to edit the associated publications and subscriptions to align with the updated topic structure. The following table describes the effects of topic structure updates on data in the publication repository and on the associated publications and subscriptions, and the resulting optional or required changes to the associated publications and subscriptions.

Topic Structure Update	Effect on Data in Publication Repository ¹	Effect on Associated Publications and Subscriptions	Optional/Required Changes to Associated Publications and Subscriptions
Add table	Table added	None	Optional: To publish and to consume the additional table, edit the mapping to include the additional table. If you do not update the mapping, data in the table will not be published to the publication repository and subscribers will not receive it.
Delete table	Table deleted, including data that was published to the table	Become not valid	Remove references to the table from the mapping of publications and from the mapping and the filter of subscriptions.
Add column	Column added	None	Optional: To publish and to consume the additional column, edit the mapping to include the additional column. If you do not update the mapping, data in the column will not be published to the publication repository and subscribers will not receive it.
Delete column	Column deleted, including data that was published to the column	Become not valid	Remove references to the column from the mapping of publications and from the mapping and the filter of subscriptions.
Rename column	Column name updated	Automatic subscriptions with filters and joins become not valid	Run the subscription wizard for all associated subscriptions.
Change column physical name	Physical column name updated	Become not valid	To publish and to consume the column with a new name, edit the mapping to change the name. If you do not update the mapping, publishers will not publish and subscribers will not receive the data in the updated column.
Change column data type	Column deleted, including data that was published to the column, and another column created with new data type	Become not valid	Remove references to the changed column from the mapping of publications and from the mapping and the filter of subscriptions. Optional: To publish or to consume the column that is created with the new data type, edit the mapping to include the new column. If you do not update the mapping, data in the new column will not be published to the publication repository and subscribers will not receive it.
Increase column precision, scale unchanged	Column updated	Become not valid	Run the publication or the subscription wizard for all associated publications and subscriptions.
Increase column precision, increase scale by a lower value than the precision increase or by the same value as the precision increase	Column updated	Become not valid	Run the publication or the subscription wizard for all associated publications and subscriptions.
Any other precision or scale updates	Column deleted, including data that was published to the column, and another column created with updated precision or scale	Become not valid	Remove references to the changed column from the mapping of publications and from the mapping and the filter of subscriptions. Optional: To publish or to consume the column that is created with the new precision or the new scale, edit the mapping to include the new column. If you do not update the mapping, data in the new column will not be published to the publication repository and subscribers will not receive it.

Rename Saved Search

Table of Contents

Operator Guide

Operator Guide

Topic Structure Updates

Topic Structure Updates