I have been tasked with a project where we have 4 identically constructed databases with different customer data in each running on premises using MSSQL and Microsoft Dynamics 2016. I need to export specific customer data from each of the 4 databases and import that data into a MySQL database that is hosted off site with our web site. This data will then be periodically uploaded to the website database either with triggers or at a timed interval.
As I have very little experience with this type of database project, I am seeking information on how this can be done and what basic steps are needed in order for this to work. Any additional details would be appreciated.