I have a centralized oracle database server. I also have approximately 105 oracle public database links setup to point to 105 different oracle servers to connect to each oracle database.
I am in the process of migrating the centralized oracle database server to sql server but keeping the 105 remote oracle database servers the same for right now. My question is does sql server have something similar (database links)? I see that you can link servers but wasn't sure if there would be an easier way to set this up instead of having 105 linked servers.