Solved

ms sql server with limited bandwidth

Posted on 2014-03-04
2
178 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

758 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

17 Experts available now in Live!

Get 1:1 Help Now