66 pounds return london stanstead <-> cologne ...
manchester or liverpool is gonna be difficult to get cheap flights for.
there's not much time either - i.e. fares go up.
after march 30th ... www.hlx.com (cheap german airline) will fly from
manchester to cologne.
On Wed, 2003-02-05 at 14:12, Anne Thomas Manes wrote:
> What are the reasons why that database links don't work? What is the volume
> of data that needs to be transferred? My initial reaction to this scenario
> is to use database synchronization technology. I probably wouldn't consider
> using XML or Web services.
>
> Anne
> -----Original Message-----
> From: Ranjith Kodikara [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 05, 2003 12:02 AM
> To: [EMAIL PROTECTED]
> Subject: Data Transfer with XML between two DB's- a Real world Case
>
>
> My customer has a requirement like this. There are several locations of
> that organization (my customer). They have an Oracle database in each of
> their locations. There is a central server. When daily transactions are
> processing, they update their location databases and at the end of the day,
> they have to transfer those data to the central server. Currently we are
> doing this with Oracle database links and due to so many reasons this is not
> 100% successful. Communication is through internet dialup connections (we
> can�t tell them to upgrade those lines)
>
> We are hoping to go for XML technologies in order to do this data
> transfer. I have knowledge on XML technologies, but not practical
> experience. But in this case there is no one in the central server to do any
> thing. People in locations should be able to transfer data of that
> particular day to the central server at the end of the day.
>
>
> There are 15 locations plus a central server. When location A finishes its
> works, it sends its data to the central location. (When it sends those data,
> it (A) updates a flag in the database records. It can identify unsent
> records by those flag.)
>
> Then the Oracle database in the central server should be updated with
> location A�s records.
>
>
>
> At that time the database in the central server would have been updated
> with other locations data (for an example, location B�s data). Then at the
> same time those data should go to location A and location A�s database
> should be updated with those location B�s data that the central server
> already have.
>
>
> My question is how can I do this? What s the best technology to use? (Web
> Services etc.) Can you recommend a book or some of web resources?
>
>
>
> There is no one in the central server to do this. I hope the location user
> to do this.
>
>
>
> Still I am wondering which technology to use. I already experienced in
> JSP, Java and Servlets. I have done some works with Xerces, Xalan and
> WebServices.
>
>
>
> If I am going to use Axis for this,
>
> an I do this with Axis ?
>
> Is it reliable Axis to do this? (Because this is a critical real world
> application)
>
> I appreciate if some of you give me some guidance here.
>
>
>
> I would greatly appreciate your response.
>
>
>
> Thanks and best regards,
>
> Ranjith Kodikara
>
> [EMAIL PROTECTED]
>
--
Dr Roger Menday
Zentralinstitut f�r Angewandte Mathematik (ZAM)
Forschungszentrum J�lich GmbH
D-52425 J�lich
Germany
t +49 2461 614340
e [EMAIL PROTECTED]
w http://www.fz-juelich.de/zam/ZAMPeople/menday.html
