Can modifying tables on target break the replication?
We need to make DDL changes to replicated tables on the APPLY side.
Create index: YES or NO
Drop index: YES or NO
Adding a column: YES or NO
Are these changes going to break the replication procedure?
There is no harm in creating or dropping index and adding a new column on the target side. These changes on target side do not break replication.
Please note that If DDL replication is enabled then we have to make sure that we do not create indexes on the source with the same name as target.
Please sign in to leave a comment.