Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Can we synch two SQL Server using they Synch platform ? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am trying to use the Synch framework to synchronize two instances of SQL server , but the problem which I am facing is the local provider is only accepting SQL CE version and not accepting SQL server , so is there any possible way to have this class works for two SQL Servers instances as server and client ?

    Please if any body has answer or code sample I will be gratefull .

    • Moved by Hengzhe Li Friday, April 22, 2011 3:28 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Sunday, April 5, 2009 6:30 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    SyncAgent.LocalProvider property expects ClientSyncProvider object reference. In fact, Microsoft deal builtin Client Sync provider for SQL Server Compact but you may create your own provider as well. Here you can see a SQL Server Express custom provider that shows the way you can use this kind of providers.

    In the other hand, you may consider peer to peer approach (aka collaboration scenario). This scenario, which is supported by Sync Services for ADo.NET 2.0, let you decide at runtime, which provider plays as Server or Client, and you can use a couple of SQL Server provider like you do so in off-line scenarios. Can find further information here.

    Hope it helpfull

    Best regards,,
    José Miguel Torres
    • Marked as answer by Anas Bahsas Monday, April 13, 2009 10:48 PM
    Monday, April 13, 2009 5:18 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    SyncAgent.LocalProvider property expects ClientSyncProvider object reference. In fact, Microsoft deal builtin Client Sync provider for SQL Server Compact but you may create your own provider as well. Here you can see a SQL Server Express custom provider that shows the way you can use this kind of providers.

    In the other hand, you may consider peer to peer approach (aka collaboration scenario). This scenario, which is supported by Sync Services for ADo.NET 2.0, let you decide at runtime, which provider plays as Server or Client, and you can use a couple of SQL Server provider like you do so in off-line scenarios. Can find further information here.

    Hope it helpfull

    Best regards,,
    José Miguel Torres
    • Marked as answer by Anas Bahsas Monday, April 13, 2009 10:48 PM
    Monday, April 13, 2009 5:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Excellent answer , I will go through the whole link and read it .

    This is what I was seeking long time ago.

    Thanks Torres.

    Monday, April 13, 2009 10:53 PM