none
Need simple C# example using SQL Server change tracking and one table to sync over HTTP

    Question

  • Hi

    I want to 2-way synchronize 1 SQL Server table with another SQL Server database across the internet using either WCF or Restful HTTP. Both SQL Servers (2008 R2) would have change tracking enabled on the table requiring synchronization.

    Ideally I would start with a console application which works on both servers as this should be a peer-to-peer solution.

    I've looked though many examples but they either don't seem to use SQL Server change tracking, only work with servers on the same network, or seem very complicated.

    Can you help me with some code examples?

    Many thanks
    Andrew

    Friday, April 11, 2014 4:10 PM

Answers

  • I realize now that the SyncFX is not really appropriate for my application. I will just maintain the 2 systems with my own syncing implementation which actually pretty trivial.

    Thanks for you help.
    Andrew

    • Marked as answer by j055 Monday, April 14, 2014 8:43 AM
    Monday, April 14, 2014 8:42 AM

All replies

  • SQL CE is the only supported client side if you want to use SQL Server Change Tracking.

    here's a sample of using WCF using the peer to peer providers: Database Sync:SQL Server and SQL Express N-Tier with WCF

    ignore that it says SQL Express, the same sample can be used with LocalDB, Express, Server or Azure SQL Database.

    Friday, April 11, 2014 4:15 PM
  • I realize now that the SyncFX is not really appropriate for my application. I will just maintain the 2 systems with my own syncing implementation which actually pretty trivial.

    Thanks for you help.
    Andrew

    • Marked as answer by j055 Monday, April 14, 2014 8:43 AM
    Monday, April 14, 2014 8:42 AM