Database Sync:SQL Server and SQL Express 2-Tier

Shows how to use the Sync Framework 2.1 database providers to configure and execute synchronization between a SQL Server database and one or more SQL Server Express databases. This sample demonstrates syncing with a central server as well as between two clients.

C# (91.8 KB)
1.9 Star
6,027 times
Add to favorites
E-mail Twitter Digg Facebook
Sign in to ask a question

  • Will this use SQL 2008 change tracking on SQL 2008 databases
    1 Posts | Last post November 29, 2011
    • I have a server with SQL 2008 R2 and clients that have SQL Express R2. Will this use the Change tracking feature in 2008 and if not are there some additional steps that can be introduced to do so?  Thanks
  • Can it sync record by record?
    1 Posts | Last post November 11, 2011
    • Can it sync record by record?
  • Problem using the sample
    1 Posts | Last post November 11, 2011
    • after i installed i am facing some error below:
      A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
      hostName is my computer name(EPOINTCOOL) but on microsoft sql server 2008 the server name is EPOINTCOOL\SQLEXPRESS, server type is database engine, authentication using back to windowns authentication. I have done it but still come out above error msg.
      can you gv me some suggestion?
  • Problem using the sample
    1 Posts | Last post September 12, 2011
    • I had below exception when I use the sample for remote sql server:
      "An unhandled exception of type 'Microsoft.Synchronization.Data.DbSyncException' occurred in Microsoft.Synchronization.dll
      Additional information: Failed to Execute Provider Command 'SelectNewTimestampCommand'. The transaction was rolled back. Ensure that the command syntax is correct and check the inner exception for any store-specific errors."
      could any body help?
  • build error
    2 Posts | Last post April 26, 2011
    • Hi
      What needs to be done to upgrade this to Sync framework 2.1?
    • Just update the references in each project.  Works fine after that.