Loading

Without using link server any other way to fetch data.

Tuman Sahu

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sanjay Gangurde6y ago
No, only Linked server can be used to fetch data from another server but if you want to retrieve data manually then you can use SSIS to retrieve the data.
0