Solved

ms sql server with limited bandwidth

Posted on 2014-03-04
2
179 Views
Last Modified: 2014-03-28
I work in a office building that have t1 1.5 upload and download in internet connection.
And I want to develop an asp.net/c# intranet with MS SQL database 2012 for the internal office and allow website hosting in different location like goaddy.com to read/write the ms SQL Server, and I have the following worries.

1. Speed issue to load the database from the external website.
2. And with that slow speed it may even impact local office users.

And I am thinking to have co-location to host the database but I need to sync the data between two databases. and I think it is working but again speed is the issue.

Want to ask the experts we have any options in this case.

Thanks
0
Comment
Question by:CoolDev2014
2 Comments
 
LVL 16

Accepted Solution

by:
Shaik M. Sajid earned 500 total points
ID: 39905612
Option1 :

try azure platform...

where u can sync your database to cloud ...

which will sync your SQL on cloud...  

with storage: SAN physical to cloud

which will do the block level replication which consumes very less bandwidth. and you can replicate database over lan

from there u can publish you site... it's a highly reliable solution...

http://oakleafblog.blogspot.com/2010/01/synchronizing-on-premises-and-sql-azure.html
0
 

Author Comment

by:CoolDev2014
ID: 39906942
Thank you very much for the information. It is very helpful.

Have below questions.

1. Is the data data sync is instant?  In my case, I will have intranet app.  in the office and website outside of the office. They both will instantly changes information.

2. Do you know any efficient way to test the bandwidth while it is syncing?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now