As you have been told in the comments, ETL may be the best option in these cases, but for my part I can recommend that it would be better if you talk to a professional, he will know what is best in these cases, what he should recommend and above all, it will tell you what you should do and how you should do it, if you choose this option, try this group of professionals
https://symfa.com/expertise/etl-elt-solutions I had once contacted them for another type of question and in addition to explaining extremely well, they have prices very accessible