On Friday, January 14, 2005, at 11:47AM, Myles Wakeham <myles@...> wrote:

>
>> On 13-Jan-2005 17:20:51, Diego Barros wrote:

<snip!>

>What we normally do is to have ALL of our transactional access done through
>Stored Procedures, which then would give you a guaranteed place to fire off
>another SP when the appropriate transaction occurs that triggers the data to
>be sent to the other system.
>
>But to be honest, in these days of B2B transactions, I'd just forget about
>doing this at the database level and create a SOAP web service transaction
>to your head office with the data in XML format. Its just so much easier to
>work with this way, but it assumes your headoffice have some available web
>server to receive the requests as they come in.

Hi Myles,

Unfortunately there is no internet access from the client to head office. The export of data from the client to head office will have to be done via some storage media, floppy disk, flash drive, or some such method.

Cheers,
Diego