> Hi,
> What is the best way to extract info from one table in a database and
> write it to another table in a remote database (that has the same table
> structure)?
> I am looking to have a number of databases update a central database
> periodically - say every hour. Could a stored procedure be used?
>
> Thanks for any info
> Geoff
>

use one of the replication tools around - see www.ibphoenix.com for a
listing
Alan