Microsoft cloud computing component "Huron"-synchronize your data to the cloud computing data center (Azure)

Source: Internet
Author: User

Microsoft cloud computing component "Huron"-synchronize your data to the cloud computing data center (Azure)

What is Huron?

Definition in one sentence:HuronAllows your local database and cloud computing database (Cloud DBData Synchronization provides a complete, simple, and efficient synchronization solution.


Technical Features of Huron:

1. The first step is to use the existing technical architecture of Microsoft:MSSQL Data Services(Cloud DB) And Microsoft Sync Framework(MSF).
Ms SQL Data Services is provided by Microsoft, is located in the cloud database, and Microsoft Sync Framework is Microsoft Data synchronization Framework. Years of use and development and testing to ensure the stability of its products.

2. Using Huron, you can easily and quickly establish an enterprise data center on a cloud computing platform.

3. Using the cloud computing platform, information can be shared to mobile users, business partners, remote offices, or enterprise data resources.

4. Huron serves as a bridge. An application can be used both inside and outside the enterprise.

5. The local database supports a variety of popular products in the market: Microsoft Office Access, SQL Express, SQL Server Compact, and SQL Server. It also supports Mobile databases.

"Huron" provides the synchronization function in SQL Data Services. Allows "Occasionally Connected" applications to easily and efficiently upload and download content to the Cloud computing data center (Cloud DB). [the so-called "Occasionally Connected" applications refer: in some application scenarios, the network cannot be connected in real time (for example, a mobile phone user or a program running on a notebook). Therefore, the local cache data technology is used to store the data in a local database in real time, once the network is connected, data is synchronized from the local database to the server. This kind of program is called-Occasionally Connected applications]

Huron includes:

First, there is a database (SQL Server Data Services) on the cloud computing platform, as its Data center, to store the incoming and outgoing information from various endpoints (terminals.

Second, there is a synchronization service layer located on the cloud computing platform, which enables all data processing, so that it can efficiently synchronize with the database of various endpoints (terminals.


At the beginning of the concept of the Huron project, we considered that we could synchronize all the terminal databases with Cloud DB. Cloud DB is like an information center that exchanges database information through various endpoints (terminals. Cloud DB is an information center. Once a user changes the content, the changed data can be sent to various endpoints ). Currently, Microsoft uses SQL Data Service as Cloud DB.

During synchronization, the first step is to upload all the changed data to Cloud DB (of course, after the last synchronization ). Step 2: Download and update all changed data from the Cloud DB to the local device (do not forget that not only can you change the Cloud DB, but other terminals may also change its content ). If data conflicts exist during the update process, Huron detects and resolves these conflicts. All the above steps have been included in Huron, and you do not need to participate in the tedious steps.

Cloud DB is not just a simple Database. SQL Server Database Services provides a wide range of APIs and verification systems for you to use, you can directly query, edit, modify, and delete data in Cloud DB. Make full use of the advantages of cloud computing and cloud storage to build various applications based on Huron. These include report systems, business intelligence systems, data mining systems, and even data migration applications. In short, they have broad application prospects.

Speaking of this, you may ask, what is the actual use of Huron in terms of concept? Will it be complicated to use?

The Huron team has taken this into consideration. Generally, writing a synchronous application or Provider is very time-consuming because the synchronization technology has complicated logic. To reduce the difficulty of development and development, the Cloud Synchronization Service encapsulates most of the logic processing. Developers only need to implement a small part of the logic processing. Further, the Cloud Synchronization Service Logic includes downloading updates from Cloud DB (all updates occurred after the last synchronization) and uploading changes from local databases to Cloud DB.For developers' APIs, Huron is simplified as much as possible to ensure that developers can synchronize applications with the simplest code and at least time.

Application of Huron for enterprise data

In the construction of Huron, we also considered how to use existing enterprise data. Generally, enterprises have their own servers and a large amount of old Data, so that they cannot be easily transplanted to SQL Data Services. Enterprises that already have servers usually want to expand their servers to data centers with cloud computing capabilities. In this case, Huron is constructed in a modular manner to meet the requirements of the above enterprises. The Cloud service layer can be connected to any mainstream database products in the current market. by writing a Provider that matches the database, you can synchronize data with Cloud DB. About logical processing of the synchronization kernel-the most complex part of the entire process is completely handled by Microsoft Sync Services, and developers do not need to write any code for it, this saves a lot of time and effort.

For the convenience of users, Microsoft has developed some providers to synchronize databases. Microsoft SQL Server and SQL Server Compact (Microsoft Office Access is also under planning, but it was postponed due to the budget ). You can use these providers to synchronize the local SQL Server or SQL Server Compact database to Cloud DB. You can also download updates from Cloud DB.

Summary: Huron provides the following functions:

· Sharing the entire cloud Database

· Share a set of specified tables on the cloud

· Subscribe to released databases on the cloud

· Share the hyperlinks of published databases on the cloud. You can share locations by email.

· Automatic synchronization is completed by developing a synchronization plan and background synchronization is supported (no user involvement is required)

· Set access permissions to restrict access by illegal users

· After the database is unsubscribed, the database remains on the cloud, but the local copies are no longer synchronized.

· Completely remove databases from the cloud to ensure the security of user data


Tags: MS Azure, Cloud dB, MSF, OCS

Related Articles: Microsoft cloud computing component "Huron"-Latest Developments and Applications


  • Author: Liang yiming
  • Source:
  • Liang yiming, the author of this article, shares the copyright with the blog. You are welcome to reprint this article. However, you must keep this statement without the author's consent and provide the author's name and original article connection clearly on the article page, otherwise, you are entitled to pursue legal liability.



  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.