August 12, 2008 at 1:25 pm
Hi everyone...
I'm new here. Sorry if this is too basic.
I have a scenario where our application is installed in many locations. Each location has it's own SQL2005 database that houses the locations data.
What I want to be able to do is have a 'Master' database that is located in a "Central Office" that houses all of the information from each of the locations. Would replication be the proper solution to this situation?
I appreciate any tips or feedback.
*** By the way... I'll continue to search the forums as well.
Thanks again!
MasterDB (Want this one to contain all data from the 3 location)
Location1DB Location2DB Location3DB
August 12, 2008 at 3:41 pm
It sounds like Transactional Replication would be appropriate for your scenario with the remote locations as publishers and the central office as subscriber. Check "Selecting the Appropriate Type of Replication" in BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/c76b01f6-0b1e-4b60-8d76-07faf0259129.htm.
Greg
August 13, 2008 at 7:12 am
Thank you for the response. I'll go to the BOL and do some reading. I just wanted to make sure I was on the right path 🙂
Thanks again.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply