Need help on the below requirement...
I have to perform ADF migration from 90(source and target Azure MI databases) For Example Source on-prem servers(data server1, data server2, data server3,...data server90) to Target Azure MI Servers(Azure MI Database1, Azure MI Database2, Azure MI Database3,....Azure MI Database90)
On-Prem dataserver1 db1 (Self Hosted Integration Runtime1)---> Azure MI Database1
My question is, do I need to create 90 (Self Hosted Integrated Runtime for each on-prem source data servers) and 90 pipelines for this similar activity, or is there a way to optimize it so that one self-hosted integration runtime service and same pipeline can be used for all 90 migration?
Any help or suggestion would be a great help as I am new to ADF...
Below are my pipeline activities... enter image description here
