Remote Servers Data Integration

[amirj]

I have developed a Client/Server Solution for a Company.
That has two branches in two different cities.

And system is being running in both branches SEPARATLY.
Now they want some complex reporting system on web in which
data should be consolidated and they can view both branches
status in one go on same page.

Kindly advise me how can i provide this facility to them
to consolidate desired data and produce report on web?

REMEBER, reports are too complex and can not designed
directly through TABLES JOINS. I am able to write some
processes for collection of data and as well as design
reports.

But how can i fetch data from remote servers and merge them
on one place?

Please guide me irresrespective of development lanuage. I
need statndard way what is being using for this type of
situations.

Thanks

[hellomadhu]

you can replicate the remote database at ur place.
you can also set a time frame so that the data gets replicated for every time slot u set ( say for 1 hr).

as far as merging of data is concerned, sorry i have no idea.

but once u have both databases at the same place. i dont think it will be a problem for u to work with.

[amirj]

i don't want to replicate, bcoz data volume is very large and Reports are MIS Nature. I just want to get selected data, move them in another location/web server and upload reports.

i am grateful for your reply.

[hellomadhu]

FYI: u have 2 types of replication.

one will replicate entire database everytime and the second option is to replicate only the changes.

the second option is not time consuming and fast enough.

i dont know wether it is useful to u or not. anyway its just FYI