Cheers Gary I appreciate how replication gracefully handles new columns etc, however changes needed to be made with the ETL setup would be made by the BI team so thankfully...

Replication was used as bandwidth was and still is at a premium between where the live SQL servers are and here where the UAT and reporting servers are. The previous...