I am a new user using xDB to replicate data from PostGRE to MS SQL server for reporting and business intelligence. Our production datbases undergo varioius schema updates 3 or 4 times annually. What are the best practices for updating schema on SMR replicated databases? Is there a better way then to:
Remove scheduled replications
Remove impacted tables from publication
Manually remove impacted tables from MS SQL target DB
Apply schema changes to impacted tables
Re-Add impacted tables to publication
Re-Add scheduled replications
Looking for best practices others may have devloped.