Hello, I have a desktop client that is using the sync framework to synchronise the database to the server. I am experiencing problems occasionally with it "Cleaning up" the tables change tracking. I did some research and found a post on the internet that gave some code that resets the anchors on the table and then resynchronises. This ...
When using MSF, is it implied in the technology that the sync tables are supposed to be 1-1? The reason I'm wondering is that if I'm synching from a SQL2005 database to a SQLCE, I might want the CE one to be a little more flattened out so I can get data out with a simpler SELECT statement (as CE does not support sprocs). For example, I...
This question is about the Microsoft Sync Framework. Is it possible to sync a DbServerSyncProvider with a KnowledgeSyncProvider? (SqlCeSyncProvider for example). I have a DbServerSyncProvider that was written a long time ago and I would like to sync it with SqlCeSyncProvider so that I can have peer to peer syncing. Thank you, Alex ...
Is it possible to apply a DbSyncScopeDescription to an existing SqlCeDatabase? I'm trying to provision an existing database using a DbSyncScopeDescription built from this database. This is the code i'm using to test this out. This should give you an idea of what I'm trying to do. I get a SqlCeException on the last line with the mes...
What I have found on the 'net seems a little ambiguous whether or not something needs to be installed on the server to use the Sync Framework with SQL Server 2005. My interpretation is no, that the ADO.NET'ness of the product reaches out to the server (assuming appropriately trackable tables exist). My goal is to use SQL Compact on the...
I am using Microsoft Sync Framework for syncing server and client SQL server 2005 database. My requirement is to get summary of all changes and display it to the user before actually perform sync operation. Does any one have idea how can we get changes in microsoft sync framework before actually synchronize them? ...
Hi guys, I have this WPF application using NHibernate and lazy data loading. I also use Microsoft Sync framework to sync data to and from a central database server. So what happens is that when I modify data on the central database server and sync it with the WPF client app, I can't get the latest data to be displayed to the UI since NHi...
For those of you familiar with the Microsoft Sync Framework, this question is for you. It's regarding application versioning. Let's say that I release version 1.0 of my software and a local database sdf file is created from the version 1.0 web service, and life goes on for a while, and the user uses the application and puts data in the l...
I have not found any document for using MS Sync Framework + WCF and using streaming instead of buffered messaging. Does anyone have any reference on how to implement it? Thanks! ...
The SqlMetadataStore from the Sync Framework implements a MetadataStore using the Sql Compact Edition. To understand better the implementation I'm trying to open the store with Management Studio (or even the Server Explorer in Visual Studio). But it asks me for a password. What password should I use? Thanks! ...
I'm using sync framework to synchronize sql server 2008 database with sqlCE on mobile device. Everything looks fine besides some problems. One of them is: If i want to sync 1000 or more rows, i get OutOfMemory Exception on mobile device(tho the sync completes well, because after it i check the data of some rows and it looks synced). I th...
I have mobile application, so i dont want to send/receive whole changes in tables..Just some data, that meets some filter terms. Is it possible to achieve with SF; if it is, please provide some resources to read about it, because i found almost nothing. Thank You. ...
We have a few thousand Windows XP client machines on various customer sites that are all running some interactive software which is instrumented to collect anonymous usage data. The client machines use some old, old, old client-server software that uploads the data to an internet-based server, pushes configuration info back down to them ...
I have a WM device (with CF3.5 on it). It's not always connected to network. It can sync through web service with the server database. I want to know if there is possibility to get traffic value between mobile device and server (and not just uploaded/downloaded changes from sync statistics)? ...
I'm having some trouble getting started with the Sync Framework. In doing research, it looks like the Sync Framework is a better fit for what we need than replication or a custom-rolled solution. Basically, we need to keep some datasets synced from our central office with every store in the company to overcome shortfalls with crappy DS...
I've asked about each of these technologies separately, and really haven't found a suitable answer. We have a server in our central office running SQL Server 2005 Enterprise that has several large (large in the sense that DSL is the limiting factor) databases that we need local copies of at each of our locations. We currently have a fe...
In a current project we use sychronization between SQL server 2008 and and SQLCE on a windows moblie device. The server runs a WCF service. Due to the possibility of large data to be synchronized we have implemented a batching. Later I've noticed that the device stops to stops to asks for more batches, even if it isn't done. The times I...
I'm using SyncFramework 1.0 for syncing a SqlCe 2005 database with SqlServer 2005. I'm setting the Sync anchor like this... CommandText = "Select @sync_new_received_anchor = GETUTCDATE()", but syncframework converts this value to a string with too many decimal places.... exec sp_executesql N'SELECT [Company], [ServiceAreaId], [Cost...
I'm trying to upgrade an application that uses Sync Framework 1.0 to synchronise a SqlServerCe database with SqlServer 2005. On the client, the existing database already has change tracking enabled, but when the sync is initiated SyncFramework 2.0 fails to find the last Sync Received anchor and then tries to re=initialize the Change trac...
Hi, We have a database running on a shared host via SQL Server 2008. We are now in the position, due to performance constraints, where we have to move the database, along with a website. We use change tracking on the database so that clients can sync using the sync framework. My question is: is the change tracking table stored within th...