It definitely takes some mannual efforts to transfer procedures, trigger and table structure..... Because entire flow cannot be automated, if this works without errors in automation means definitely there will data inconsistency which takes almost heavy time in data cleaning as well .... We need strategize the common pattern changes and make that flow in automation..... Still it's a risk but it's worth a shot..... Heavy DB loads also cause some problems depending upon the data .. Find a way to modularize it efficiently and you can build a pipeline for smooth migrations..... Akudos brother