We have used free sights to do ETLs of disparate systems into one system with SSIS which has been very helpful in allowing us an automated way to load our SQL tables daily when we need it as well make sure all transactions are correct before going live.
I think there should be more options available such as being able to set up rules so that certain fields can only go between 2 related databases or even better if you could create custom flows within your database itself! This would save time since i dont usually want my developers writing complex code just because your DB design needs tweaking from version 1 to another! Very easy setup process but not much flexibility once implemented! If this solves most issues then maybe companies will realize how important having proper logging/auditing capabilities really matter especially during production releases where downtime must never happen!! Also allows me some peace knowing its working properly at any given point without someone needing constant manual upkeep (as.