xmlhttprequest or ?

[fmrock]

Hey everyone.

I have a project where I need to pull data from another server from my parent company. Servers not on the same network and cant connect to that database directly.

Option 1... pull the data from one database to the other and generate the graph i need from the back up of the data.

Option 2, have my project make an XMLHttpRequest to some pages on the other site, have that site create the html I need and display that in my app. Is XMLHttpRequest the right technology? Is there something else?

I really dont want to push the SQL from one database to the other. so any ideas would be great.

 

[fmrock]

BTW.. using ASP.net 4 C# and Visual studio 2010

 

[jmeckley]

you'll need to expose a call from one server to another. whether that's over http or another communication port doesn't really matter.

something to consider is the preformance/latency of the this operation. if possible, push the data transfer "off line" and display replicated/read-only data to the user.

Jason Meckley
Programmer

faq855-7190
faq732-7259

 

[ca8msm]

I think I'd go for having a scheduled task that is responsible for transferring the data over at regular intervals, unless you really need the data to be in real time in which case a web service on the ather machine may be a better option.

If they are both SQL Server databases, a SSIS task would be a good option.

Mark,

Darlington Web Design[tab]|[tab]Experts, Information, Ideas & Knowledge[tab]|[tab]ASP.NET Tips & Tricks