locked
Sync between SQL Server 2005 and SQL Server 2005 database RRS feed

  • Question

  • We want to distribute / synchronize data from our Datawarehouse (MS SQL Server) to external customers (also MS SQL Server). The connection has to be secure, because we are dealing with trusted data. Transmission of data from our system to external client system must be via the http/https

    In addition it is possible that the clients still run their systems with an older database schema, so already existing tables and columns should be transmitted and non existing ones should be ignored.

    Its most likely that we will have large database updates and the updates have to arrive in almost real-time.

    And it is definitely necessary that the data is stored in a client side datawarehouse / SQL database.

    The whole process should also include good monitoring possibilities in case something goes wrong.

    We started to develop our own .NET solution but I thought it should be almost a common problem to exchange data between different systems.

    Does anybody know if using Microsoft Sync Framework is a good solution for that or if there is a better way?

    Any help is appreciated!

    • Moved by Max Wang_1983 Thursday, April 21, 2011 11:05 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Monday, October 19, 2009 9:57 AM

Answers

  • Hello,

    From what I have read from your description, Microsoft Sync Framework should be able to handle your requirements.

    SQL Server - SQL Server synchronization is definitely one of the scenarios handled by the framework.

    I suggest you start looking at some of the articles on Database Providers / Syncrhonization.

    http://msdn.microsoft.com/en-us/sync/bb887608.aspx

    One of the requirements mention that you want to synchronize "almost real time".

    With Sync Framework, synchronization is started by the application, thus the application might have a periodical background sync,

    or have some logic to start sync when there are some changes.

    Thanks,

    Patrick 
    Monday, October 19, 2009 6:41 PM