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 |
|
aiyou99
Starting Member
3 Posts |
 Posted - 2012-04-04 : 21:22:22
|
| 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?www.manwearuk.com |
|
|
SQLSoldier
Master of MCMs
9 Posts |
Posted - 2012-04-05 : 20:19:09
|
| Not really enough information here to make a determination. How much traffic will you need to support? Do you need to scale-out the system for performance reasons or to make sure that all 3 teams have the best possible connection to the database? Does Autodesk Vault allow you to make schema changes to the database (merge replication will have to add a rowguid column to the table if one does not already exist and adds a lot of tables and triggers to the database).Depending on your needs, you may also want to consider peer-to-peer replication.Robert L DavisMicrosoft Certified Master: SQL Server 2008Sr. Product Consultant and Chief SQL EvangelistIdera |
 |
|
|
|
|
|
Am I right?