Synchronize local server database into hosted server database

See more:

SQL-Server-2005

C#

ASP.NET

, +

haii Seniors ...

What My requirement is , there is a web application running finely..

due to its 'heavy' nature, application takes too much time for its functioning..

Firm has Several branches and is it possible to deploy the application in local server and Synch data To the hosted Server so that other branches also get that, without much effort.

And Secondly is it possible to keep a db locally and update it Frequently and use use that in time if the hosted server is not available or internet is not. can we change the the web config to change the connection string dynamically..
Is there any tool SQL is Providing for this functionality..
pls help me..


thanks in advance..