Without using link server any other way to fetch data.

Question

Hi.

I have two data server, both server can remotly access, i am trying to connect though linked server option in sql server. but till not success.

so guys any other option in asp.net through i can get data of remote database  and store in my local server.

It is a real time database day to day update in remote  server.