SQL Server Replication for EA repository

[jps]

Hi all,

We are doing development in both the US and India.  We are using MS SQL Server for our repository and this is located in the US.  We have found EA’s responsiveness when connecting to this repository from India to be flat out terrible.  I’m wondering if it would be possible to use SQL Server replication to replicate the database and improve performance.

Have any of you tried replicating a SQL Server based EA repository?  Did you use Transactional Replication or another type of replication?  Any guidelines or pointers?

Thanks!

[Dan_Lundy]

Hi,

Unfortunately, I do not have  any immediate answers for you. Oh hope though - I have a similar situation with an office in Minnesota and one in California. I am attempting a variety of schemes and will post back what seems to work for me.

DanL

[thomaskilian]

Not a DB specialist though but the replication mechanism will not produce better results as long as the bandwidth is too small. As you work in real different part of the world it should be possible to work with snapshots that could be synched at certain times. Synchronous updates should be prohibited by some administrative means. Just an idea  :-/