syncframework

Using the MS sync fx, some changes fail to apply

Hello. I'm using the sync framework to sync between an SQL-Server and an SDF. I'm using VS-2010 Local Database Cache to do the actual sync, with the ConflictResolver set to client wins. I tried to sync changes between the two, having modified only one side, and yet some records fail to sync to the other side (from SDF to SQL). In the S...

Microsoft Sync Framework error deleting foriegn key linked tables

I am using Microsoft Sync Framework 2.1 with SqlServerCE. I have a main table with a child table linked by a foriegn key. When I delete the main table entry, it fails since there are items in the child table (which have also been deleted.) How do I tell Sync what order to delete rows from tables in? ...

Microsoft Sync 2.1 : Oracle 11g -> SQL Server 2008 Sync : Cast not valid Exception

I am trying to sync tables in a Oracle 11g and Sql Sever 2008 databases using the Sync Framework. I used the Database Sync: Oracle and SQL Compact 2-Tier Sample as a base and was able to extend it to sync data between the Oracle 11g and Sql Server database using the same order and order_details tables. I used ODP.NET data access libra...

Sync Framework how to use dynamic connection string

Hi, In my scenario I synchronize client database SQLCe with server database Sql Server 2008. Client database is in users folder so that connection string is built dynamically on each app. Is it possible to set dynamic connection String in syncprovider ? thanks for any help ...

Microsoft Sync framework source code

Hi, Does anyone know if the MS Sync Framework source code is available and how to obtain it ? ...

Is it possible to define a custom tracking mechanism with the Microsoft sync framework?

I am currently evaluating the Microsoft sync framework as a possible solution to sync data between two SQL databases. The examples I have seen so far rely on "tracking tables" containing the information used to track changes to be synced, with triggers on the main tables to keep them up to date. My database already contains lots of this...