locked
Sync between sql express 2005 and sql server 2005 RRS feed

  • Question

  • Hi,

     

    I have sql express 2005 on my client and I need ti sync between sql express 2005 and SQL Server 2005.

     

    Can I make use of the ADO.Net sync service for this.

     

    Please do let me know

    • Moved by Max Wang_1983 Friday, April 22, 2011 7:14 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, February 12, 2008 9:19 AM

Answers

  • Would you like to try Peer to Peer sync from Microsoft Sync Framework (which is not the same as MS sync services), http://msdn2.microsoft.com/en-us/sync/bb821992.aspx.

     

    Thanks,

     

    This posting is provided "AS IS" with no warranties, and confers no rights.

     

    Tuesday, February 12, 2008 3:21 PM
    Answerer
  • 1. The current P2P provider would support this configuration. However the hub-spoke provide (Sync services for ADO.NET) does not support that.

     

    2. Using the Sync framework (specifically the file sync provider or you could write your own provider), you could sync files and folders. Also try out the power toy - Synctoy (built on sync framework) to do the same. (http://forums.microsoft.com/sync/ShowPost.aspx?PostID=2891420&SiteID=75)

     

    3. Microsoft Sync framework is a generic framework to sync 2 end points for any kind of data. ADO.NET sync services is a specialized provider written to sync relational data (SQL Server central hub to SQL Compact clients). There is a P2P version of the sync framework that enables synching relation data between 2 peers - say 2 SQL servers.

     

    4. The sample express provider is now posted here that you could use for hub-spoke model for express clients.

    http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=1200

    Wednesday, June 25, 2008 10:43 PM

All replies

  • Would you like to try Peer to Peer sync from Microsoft Sync Framework (which is not the same as MS sync services), http://msdn2.microsoft.com/en-us/sync/bb821992.aspx.

     

    Thanks,

     

    This posting is provided "AS IS" with no warranties, and confers no rights.

     

    Tuesday, February 12, 2008 3:21 PM
    Answerer
  • Hi Zhou,

     

    Thanks for the link,

     

    I am going to try this out and see if its going to be of help.

     

    But couple of questions before I start with this:

     

    1: Would it support SQL Express 2005 on client and SQL Standard or Enpterprise 2005 on the server.

    2: Is there any option to sync files/folders or any framework available to achieve this

    3: What is the basic difference between Microsoft Sync Framework and the ADO.Net sync services

    4: I am waiting for the ado.net sync service provider for SQL Express 2005, any idea when that would be available.

     

    Thanks for the help

    Thursday, June 5, 2008 6:42 AM
  • hi, Any Update for this questions? I am also curious to know the answer for the above questions.
    Monday, June 9, 2008 6:24 AM
  • 1. The current P2P provider would support this configuration. However the hub-spoke provide (Sync services for ADO.NET) does not support that.

     

    2. Using the Sync framework (specifically the file sync provider or you could write your own provider), you could sync files and folders. Also try out the power toy - Synctoy (built on sync framework) to do the same. (http://forums.microsoft.com/sync/ShowPost.aspx?PostID=2891420&SiteID=75)

     

    3. Microsoft Sync framework is a generic framework to sync 2 end points for any kind of data. ADO.NET sync services is a specialized provider written to sync relational data (SQL Server central hub to SQL Compact clients). There is a P2P version of the sync framework that enables synching relation data between 2 peers - say 2 SQL servers.

     

    4. The sample express provider is now posted here that you could use for hub-spoke model for express clients.

    http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=1200

    Wednesday, June 25, 2008 10:43 PM