Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
doubt about Sync Service Philosophy RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I've a little uncertainty about ADO.Net Sync services,
    is MSF suitable for synchronizing two Sql Server in bidirectional way ?( not compact edition but normal servers )
    I need to do this type of synchronization by my application not automatic replication from sql server with publisher and subscriptor way.

    And how about synchronizing a Sql Server & a Mysql Database?
    And how about synchronizing an Access File & a Mysql Database?
    • Moved by Tina_Tian Friday, April 22, 2011 8:02 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Friday, October 10, 2008 7:58 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Synchronize two

    SQL servers: yes. DbSyncProvider in Microsoft.Synchronization.Data.dll in Sync Services ADO.NET is what you should be using

    Regarding MySql database: We havent tried connecting to a MySql database but DbSyncProvider is a generic relational database based provider. So you should be able to use it. We havent tested this combination so do post back if you see any issues.

     

    Access database: Access is a different database in that the change tracking and other stuff is internal to access. DbSyncProvider would not work on top of Access and you would have to write a custom Access provider.

    • Marked as answer by phpcs Thursday, April 23, 2009 7:36 PM
    Saturday, October 11, 2008 9:17 PM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Synchronize two

    SQL servers: yes. DbSyncProvider in Microsoft.Synchronization.Data.dll in Sync Services ADO.NET is what you should be using

    Regarding MySql database: We havent tried connecting to a MySql database but DbSyncProvider is a generic relational database based provider. So you should be able to use it. We havent tested this combination so do post back if you see any issues.

     

    Access database: Access is a different database in that the change tracking and other stuff is internal to access. DbSyncProvider would not work on top of Access and you would have to write a custom Access provider.

    • Marked as answer by phpcs Thursday, April 23, 2009 7:36 PM
    Saturday, October 11, 2008 9:17 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Would you please provide me a sample? I don't know where to begin.
    Wednesday, October 15, 2008 8:38 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Please download the SDK from http://www.microsoft.com/downloads/details.aspx?FamilyId=C88BA2D1-CEF3-4149-B301-9B056E7FB1E6&displaylang=en and look for Sync services samples.
    Friday, October 17, 2008 4:30 AM
    Moderator