Post

1 follower Follow
0
Avatar

Can modifying tables on target break the replication?

Question

We need to make DDL changes to replicated tables on the APPLY side.

Examples:

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?

Answer

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.

Krupesh Desai Answered

Please sign in to leave a comment.