Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft > Forums Home > Microsoft Sync Framework Forums > SyncFx - General [ReadOnly] > Microsoft Sync Framework 2.0 CTP2 for SQL Express Synchronization

Locked Microsoft Sync Framework 2.0 CTP2 for SQL Express Synchronization

    •  
      Wednesday, July 22, 2009 7:18 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote
      Microsoft Sync Framework 2.0 CTP2 is recently released and seems to have many providers that can be used for SQL server. We are looking for Synchronization of two SQL Server Express databases using the Microsoft Sync Framework..

      Please let me know if this is the best option for synchronizing two Express databases or are there any other alternatives..
      (Replication cannot be used as there is no SQL Server Standard/Enterprise edition)

      When will the Microsoft Sync Frmaeowkr 2.0 released for ReDistribution?.. We are planning to use this framework inside an application that shall be distributed to various clients..

      Thanks in advance for your inputs...
      • Moved by Hengzhe Li Friday, April 22, 2011 2:27 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
      •  
         

      Answers

      • Friday, July 24, 2009 5:58 PM
        Answerer
         
         Answered
        Sign In to Vote
        0
        Sign In to Vote
        We are currently looking at - in the next 2 to 4 months.
        Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
           

        All Replies

        • Wednesday, July 22, 2009 9:02 AM
          Answerer
           
           
          Sign In to Vote
          0
          Sign In to Vote
          Hello,

          Is this for Hub-Spoke sync or Peer-to-Peer sync?

          1. For Hub-Spoke, you can combine the technology from the (sync services for )ADO.NET in the sync framework + SQL Express client provider  (downloaded from which is from

          http://blogs.msdn.com/sync/archive/2008/06/24/sample-sql-express-client-synchronization-using-sync-services-for-ado-net.aspx).

          2. For Peer-to-Peer sync, then SqlSyncProvider (from sync framework 2.0) is a good option.

          Thanks.

          Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
             
          • Wednesday, July 22, 2009 10:06 AM
             
             
            Sign In to Vote
            0
            Sign In to Vote
            1. For Hub-Spoke, you can combine the technology from the (sync services for )ADO.NET in the sync framework + SQL Express client provider  (downloaded from which is from

            http://blogs.msdn.com/sync/archive/2008/06/24/sample-sql-express-client-synchronization-using-sync-services-for-ado-net.aspx ).

            The sample sqlexpressprovider is far from perfect. Some errors already have been resolved: http://www.8bit.rs/blog/?p=23

            And if I am not mistaken: internal it uses a DBserverprovider.  Due to that an n-tier solution is not possible.

            It would be interessting to know if there is coming a real sqlExpressClientProvider like the sqlCeclientSyncProvider. (As promised more than a year ago)


            ¿Anyone can help me with this?
            With this scenario: server n-clients
            server-> sqlexpress server
            clients ->sqlexpress
            Using the microsoft sync framework, ¿do I have to design a peer to peer solution to get support for sqlexpress?
               
            • Wednesday, July 22, 2009 11:38 AM
               
               
              Sign In to Vote
              0
              Sign In to Vote
              We are looking for a Peer-to-Peer sync.. (bi-directional)

              However, Sync Framework 2.0 is still in CTP.. any idea when it is planned for a release?

                 
              • Friday, July 24, 2009 5:58 PM
                Answerer
                 
                 Answered
                Sign In to Vote
                0
                Sign In to Vote
                We are currently looking at - in the next 2 to 4 months.
                Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.