Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kevin.wong@au.pwc.com
Starting Member
1 Post |
 Posted - 2007-09-13 : 23:58:07
|
| How would you solve this problem?Would you use replication? SSIS? Schedule stored procs? A third party data tool?We have about 50 databases located at offices around the world. There are several key tables which we need a central copy of at our Head Office. We need only the new INSERTS or UPDATES for the day to be copied to head office.The copying process should happen after business hours for that office.Some cleaning of the data needs to happen before updating head office.Our database is being installed at new offices every other month, so it's important to us that this be easy to add a new database into the schedule, ideally without needing a SQL DBA or Developer.We want something robust, performant and easy to troubleshoot.Kev |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-14 : 00:00:39
|
| Can try with merge replication, but you need dba no matter which way to go. |
 |
|
|
|
|
|
Merging 50 databases into one on a nightly basis