Solved

ms sql server with limited bandwidth

Posted on 2014-03-04
2
182 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

762 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