RE: FN-FORUM: XML Question

date posted 10th January 2007 16:55

Sounds like classic web services to me. And if the connection between
the servers is down for some reason it wouldn't matter what process you
used.

Unless you completely replicate all the data that you need in real time
between the servers (and you manage to get over any security
considerations that there may be in being able to do this) then at best
you need a way to be able to request the specific information that is
requried on the "non-SQL" site. Web services are ideal for this because
they don't require any additional port to be opened (unless you want to)
on your server because the transport is all HTTP. You can then wrap
whatever level of security you need around the request (you can run
webservices via HTTPS as well which is often recommended for this sort
of activity).

One thing to be aware of, it's better to make one "big" web service
request for a block of data than to make several smaller requests for
the data in that would make up that block. This is because there is an
over-head on each webservice request which may or may not be significant
to you.

We've implemented several systems that take this approach and there are
pluses and minuses to it !

Cheers
Andy



-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Andy
Henderson
Sent: 10 January 2007 14:50
To: Andy Macnaughton-Jones
Subject: RE: FN-FORUM: XML Question


>>>If XML is the answer how does it get parsed from one server to the
next?