We are using GoldenGate replication for SQL Server databases. I have a generated SQL deployment script that contains a combination of DDL and DML that needs to be applied to both publisher/source and subscriber/target DBs. What's the best way to handle ensuring that I can run the same deployment script on both source and target DBs while not breaking replication between the two DBs?
TIA,
-Peter