By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

combine data from different databases

P: 24
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 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!
Jan 27 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,878
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
Jan 27 '10 #2

P: 3
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?

Jan 31 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.