Hi,everyboday. I'm designing a human management system. this system will be used by the branches separately. but the head office should combine the data from different branches. due to some restrictions, the system could not base on network. so I think the only way to combine the data is to update head office database manually. I am using vb.net and sql server ro develop the system. the branches will use the databases with same structures, anybody could provide an easy way to combine the data from branches. Thank you!
-
-
If network is out of the question, then I guess so is replication. You're going to have to do it manually.
Good Luck!!!
~~ CK -
Which versions of SQL are the databases? I infer from your question that they will all be the same Vendor and Versions. If this is incorrect, please include that info as well. Also, how much data are we talking about here, and are you using any constraints within the DB?
Thanks,
LDComment
Comment