We developed a Client Server application using Microsoft Sync Framework to synchronize data between a WinForm client application (with a SQL CE Local Cache database) and a SQL SErver 2008 database server. The application is now pretty much completed, and all features seem working properly. So now we want to use Visual Studio 2008 Test ...
Has anyone got sync framework to work on a mobile device as a sync mechanism in place of RDA or Merge replication? If yes, could you point me to any resources available. If one was to start a green field compact framework based application, what would one use as the sync mechanism (sync framework/RDA/Merge replication/any other...)? T...
can microsoft sync framework sync database views ? or in your SelectIncrementalInsertsCommand can you select and join to multiple tables kinda doing something like a view? ...
I've got to implement data synchronization between a local storage that resides on a mobile device and the server DB. The thing is that our DB (which is already in production for many years) all uses an integer as the Id of a record. I'm afraid that changing it to be a GUID is currently not an alternative because it has too many repercu...
I have a table that has a version timestamp column. No creation date. Running the visual studio wizard with the localdatacache. It creates 2 triggers one for insert and one for delete. It also create an additional column CreationDate => DEFAULT VALUES TO @@DBTS + 1. First confusion : It has created and additional column with a default v...
I have a FileSyncProvider and I've written a custom implementation of the FullEnumerationSimpleSyncProvider. When files are synced from the FullEnumerationSimpleSyncProvider to the FileSyncProvider they are created correctly, but are zero bytes. When synchronising in the other direction (FileSyncProvider as source) everything works as e...
Hi, i'm new to Microsoft Sync Framework and trying to synchronise an sqlite db with sql server 2008 and so fare I read about it on the following websites: http://sqlite.phxsoftware.com/forums/p/1381/6011.aspx http://www.vitalygorn.com/blog/post/2008/01/Microsoft-Sync-Framework-Support-in-Visual-Studio-2008.aspx http://www.codeproje...
Do you have an idea what might cause the error in the title? It highlights an error in the following part of the code: SyncAdapter notesSyncAdapter = notesBuilder.ToSyncAdapter(); ((SqlParameter)notesSyncAdapter.SelectIncrementalInsertsCommand["@sync_last_received_anchor"]).DbType = System.Data.DbType.Binary; (...
It appears here: SyncAdapter notesSyncAdapter = notesBuilder.ToSyncAdapter(); ((SqlParameter)notesSyncAdapter.SelectIncrementalInsertsCommand.Parameters["@sync_last_received_anchor"]).DbType = System.Data.DbType.Binary; ((SqlParameter)notesSyncAdapter.SelectIncrementalInsertsCommand.Parameters["@sync_new_rec...
"Invalid object name 'TableName_Tombstone'" reads the rest of the exception message. I'm trying to sync sqlce with sql server 2008 and although I've attributed the TombstoneTableName a name with the following code: TableNameBuilder.TbombstoneTableName = TableName.TableName + "_Tombstone" It appears not to find it on the server db a...
So far, I know that change tracking is integrated with SQL Server 2008, and it's being done automatically. What I don't know is whether I should modify the schema by appending a "_tombstone" myself or it's being done automatically by the server. Right now when I'm attempting to access the tombstone table from the server. It results in ...
I'm looking at synchronize methods between two databases and found Microsoft Sync Framework recently. I've been trying to investigate if it suits my needs. My scenario is the following: Two SQL-databases located in different geographical parts. The remote database can go without internet connection for days at times and for some locati...
In all samples it uses the Web References to generate the proxies. But my service is a WCF service. Should I be using the NetCFSvcUtil to generate my proxy ? or shouldI just simply use the Web References one. I tried using the ones generated by NetCFSvcUtil, but I'm just stubbling on different issues. First, the FaultException for ...
Hello all, Let say, I have a table with 2 columns (OrderId and OrderDate). In the original design, OrderId is the surrogate (which is still somewhat meaningful to the end user since they still like to refer to OrderNumber 12345) PK with IDENTITY integer. Since we start to adopt SyncFx and to support offline client creation scenario, we...
Live Mesh framework used to support p2p syncing apparently they discontinued it. In preparation for the integration of Live Framework into the next release of Windows Live, the existing Live Framework CTP will be unavailable starting September 8, 2009. To learn more about this announcement please see visit this blog post In the...
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...