Subject Writing from one Database to another
Author Geoff Rees
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
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