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