Need suggesion

I have number of SQL servers like Server1, Server2… deployed in different
cities
There will be one Main Server which gets updated/sync with the all the city
servers
I'm planning to use SQL Replication technology. Is there any other method to
achieve this. Please guide me.
Thanks in advance
Thanks and Regards,
Giri H RamMohan
Hi,
Could you please provide more information from the application side. Is
it DW or OLTP?
|||Giri,
as it sounds as though the data flow is one way then transactional
replication would be suitable. Other competing technologies include
distributed transactions using linked servers and log shipping. To get a
feel for the differences between log shipping and transactional replication,
please have a look at this article:
http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I do not now, but same case i have for 3 years and it works perfect just you
need to your own VPN, then main server has to be publisher while other server
has to subsriber.
"Giri RamMohan" wrote:

> I have number of SQL servers like Server1, Server2… deployed in different
> cities
> There will be one Main Server which gets updated/sync with the all the city
> servers
> I'm planning to use SQL Replication technology. Is there any other method to
> achieve this. Please guide me.
>
> Thanks in advance
> Thanks and Regards,
> Giri H RamMohan
>
|||OLTP
Thanks and Regards,
Giri RamMohan
"Angsql" wrote:

> Hi,
> Could you please provide more information from the application side. Is
> it DW or OLTP?
>