locked
Using sync framework or insert statement to insert data from local to remote? RRS feed

  • Question

  • While studying sync framework, one question came out:

    What benefit of using sync framework?

    For example, to upload data from local to remote, I can use SQL insert statement and create a linked server between local and remote.

     

    Thursday, April 22, 2010 3:34 PM

Answers

  • In addition to Friendly's reply,

    Sync framework helps to solve a class of problems related to data movement. The framework has the design to help move data in a more efficient, reliable and manageable way. It enables some intereting scenarios such as filtering. The Data involved in sync can be database tables/rows, files, in-memory objects in different data stores. It includes different components to make writing sync solution easier, such as with Database sync provider, file sync provider, or you can write your own sync provider to sync between any stores.

    These following links are helpful for understanding the benefits of Sync Framework http://msdn.microsoft.com/en-us/library/dd918617(v=SQL.105).aspx and what you can leverage with different components http://msdn.microsoft.com/en-us/library/dd937565(v=SQL.105).aspx.

     

    Thursday, April 22, 2010 8:22 PM
    Answerer

All replies

  • Of course you can do it yourself, no doubt about that.  But consider the following benifits sync framework gives you (that you have to implement on your own):

    1. Detecting changes and only upload deltas.

    2. Conflict resolution.

    3. Recoverable sync.

    Btw I don't quite understand your notion of "linked server" between local (database) and remote (database).

    Thursday, April 22, 2010 5:59 PM
  • In addition to Friendly's reply,

    Sync framework helps to solve a class of problems related to data movement. The framework has the design to help move data in a more efficient, reliable and manageable way. It enables some intereting scenarios such as filtering. The Data involved in sync can be database tables/rows, files, in-memory objects in different data stores. It includes different components to make writing sync solution easier, such as with Database sync provider, file sync provider, or you can write your own sync provider to sync between any stores.

    These following links are helpful for understanding the benefits of Sync Framework http://msdn.microsoft.com/en-us/library/dd918617(v=SQL.105).aspx and what you can leverage with different components http://msdn.microsoft.com/en-us/library/dd937565(v=SQL.105).aspx.

     

    Thursday, April 22, 2010 8:22 PM
    Answerer