SQL server Dabatase related

See more:

SQL-Server

Hi,

We have desktop application developed in VS 2008 c#. It is a client and server application. SQL server 2005/2008 R2 is on LAN connection and client nodes will be posting data from their machine installed exe on client machine.

We have requirement to have centralize SQL server hosted on web server and will be accessed by 30 or 40 users from different location.

The issue is speed issue although it is developed on .net framework. We will be optimizing the queries.

Please suggest the best solution.

1) We have sql server and database on LAN at every location. Local user will be access this database and speed of software will be more compare to WAN connection.

Data of each sql server will be then synchronized to get MIS report as centralized and for every location.

How do we achieve the same.

2) A single Database hosted on server and each user will be accessed using internet connection their location. How to we overcome with speed issue ?

Kindly suggest hardware configuration as well as bandwidth from 9 locations with 30-40 users or suggest the best way

Thanks
MKB