Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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