I will have several dozen machines that will have the same database schema as the master database -
I would like to upload the data that is entered into the local machines up to the master system.
What steps are needed to complete this task? If there is a MS FAQ on this (im sure someone has done this) please advise...
SQL 2k on all machines - same schema
Please excuse - Lemme explain a little more - the master database, will need to fold in the information from a few of the tables that are on the distributed machines databases....
there won't be much data that goes back to the client machines (web service via XML)
just the data from the client machines (many) needs to be folded into the master data (one)