Proxy server for SQL

[gajesh]

Hello,
we have huge SQL database on remote server which slow down the application performance because of low connection bandwidth and heavy traffic.
I want to create proxy server on local SOL server. I want that sync to happen automatically between servers and no user interaction required to do so.
Is it possible?

Thanks a lot.

[Shuja Ali]

Yes it is very much possible and the term that you are looking for is known as Replication.

Look at SQL Server Replication (http://msdn.microsoft.com/en-us/library/ms151198.aspx) on msdn.