Aras Community

Welcome to Aras Community Sign in | Join | Help
in Search
Aras Community
Please Also Visit the Project Site to Download Add-Ons and Solutions
Jump to Projects

SQL Server Replication

Last post 11-11-2008, 10:45 AM by gopalnayak. 1 replies.
Sort Posts: Previous Next
  •  10-03-2008, 2:11 PM 1073

    SQL Server Replication

    Hi,

     Before implementing Aras company-wide, I  need to solicit advice on the best way to manage multiple physical locations.  We want to implement master data management, so, obviously, we can only have one database vault.  But I'm sure there are plenty of companies with more than one location who need to use replication or mirroring to push data to the local level for lower latency access & faster file transfers.

    Would anyone be willing to share how they  have set things up to access local database servers with replicated or mirrored data?  Do you also have a local web server? or can you have one web server and access the local database?

     Thx,

    ~n8


    ~ n8
  •  11-11-2008, 10:45 AM 1153 in reply to 1073

    Re: SQL Server Replication

    We are also trying to implement something similar. However, our problem is slightly simpler since most of the locations require read only access most of the times and occasional write access. We are planning to have seperate web servers for each location and sync up the DB and the Vault regularly. If someone needs to modify, they can always login to the main server and work on it. With most of the read access limited not requiring communication to the main server, we plan to cut-down on latencies and bandwidth big time. You can try this option.
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems