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.

All Forums  SQL Server 2008 Forums  Replication (2008)  Choosing the right method of ...

Author  Topic  saoodka Starting Member 1 Post Posted - 2012-03-19 : 12:46:40 Hi, I have to implement an Autodesk Vault solution to support teams at three different locations. At least two of the teams will be updating the Vault while the third will be just reading it. Currently, Vault 2012 is controlled by SQL Server 2008 SP2. From a previous thread for a similar scenario, I have learned that the best solution would be replication with merge. Am I right? Another method would be to have our SQL Server hosted on a leased server and make it accessible to all the teams. Thereby, we can avoid REPLICATION matters. Will it be advisable?