Hi, I have a clinet sdf file (sql compact) that is created by the LocalDataCache.sync in Visual Studio 2008. The server is SQL Server 2008. On the server if I do the following: CREATE TABLE test ( [firstfield] float NOT NULL DEFAULT 1, [secondfield] float NOT NULL DEFAULT 2) GO INSER...
Sync Framework synchronizes data on a table-by-table basis, but my entities are normalized across sets of related parent-child tables. This creates problems for my application where a parent row might appear on the server to be processed, but the child rows might not appear for a few seconds. If there is a connection problem between my c...
I'm using Sync Services in a C# application. When my client syncs after a long wait, they are told that tracking info is gone and to re-init the database. I can re-init, but what if the client has data that needs to be sent to the server? In this case, it's going to be lost. Is there any graceful solution to this problem? ...
Hi all, We have built a custom provider for the microsoft sync framework, how would you go about unit testing it or would you not bother with the unit testing and focus on integration tests? Cheers alex ...
I am working on an application at the minute that will originally be just installed on a client machine with a lightweight database (may SqlLite). After a while I want to add a web version of the same piece of software and with this the smart client will then be able to sync with the online version. Has anyone done anything similar, ...
I need to make a local copy of a database in a .NET app so that it can function offline. My server database is SQL Server 2005, and it's copying to SQL Server 2008 Express. It doesn't have to be anything fancy - just start from scratch (or delete the existing db), copy all tables/constraints/foreign keys, and copy data from some of the...
I'm researching a way to build an n-tierd sync solution. From the WebSharingAppDemo-CEProviderEndToEnd sample it seems almost feasable however for some reason, the app will only sync if the client has a live SQL db connection. Can some one explain what I'm missing and how to sync without exposing SQL to the internet? The problem I'm exp...
I'm working on changes to an application to have a local data store instead of connecting directly to the database server. The client app will then sync changes both ways between the server database and its local data store. I'm trying to implement the syncing solution using Microsoft Sync Framework. To be clear there is no server applic...
We are trying to implement the Microsoft Sync Framework into our application that persists it's domain using NHibernate. One of the problems we encountered is that after the Sync Framework has altered your initial database structure (adding shadow tables and triggers) NHibernate seems to get upset by throwing an toomanyrowsaffectedexcep...
I'm building an application based on the WebSharingAppDemo-CEProviderEndToEnd. When I deploy the server portion on a server, the code gives the error "The path is not valid. Check the directory for the database." during the call to NeedsScope() in the CeWebSyncService.cs file. Obviously the server can't access the client's sdf but what ...
Does the sync framework allow me to synchronise (download only) the Store Procedures on a sql server 2008 server with the Stored procedures on the SQL Server 2008 client? i.e. overwrite the SP on the client when the server SP's have been modifed or new ones created? Thanks ...
Does anyone have an example of how to use MS Sync framework with .NET webservices? I have SQL Server 2008, which is exposing data to BlackBerry devices through webservices using regular web methods. Can I use the Sync Framework to expose data through Web Services and to save it back to the database? ...
Hello, I'm trying to use Sync Framework to synchronize user data between Active Directory and an application that provides a web service. I've created two FullEnumerationSimpleSyncProvider classes, one for Active Directory and one for the web service, and created a common data type and metadata columns that can be shared by both. Curren...
Hi guys, I just kind of confused as to why I can't get to sync all expected data in one sync session. When I try to sync to the central database through WCF services, I only get partial sync, then there are still some data left that were not synched. So I still need to resync. Is there an explanation why I can't get all expected data i...
I am developing a windows mobile 6 application using .NET CF 3.5. I need to get the IP address of my desktop computer when the device is cradled in order to initiate a synchronization process from the mobile device. I have tried Dns.GetHostEntry, but this seems to return the IP address of my Pocket PC emulator. Any ideas? ...
I have an existing solution that includes Sync Services between an SQL2005 server and SQL/CE on a mobile device. The current implementation consists of additional columns in each of the server tables for date created and date updated (both datetime) supported by tombstone tables containing the primary key and a datetime to manage the de...
I'm attempting to sync a SQL Server CE 3.5 database with a SQL Server 2008 database using MS Sync Services. I am using VS 2008. I created a Local Database Cache, connected it with SQL Server 2008 and picked the tables I wanted to sync. I selected SQL Server Tracking. It modified the database for change tracking and created a local copy (...
Hi, I want to synchronize two SQL databases. But since one of the databases only requires a subset of the data I am looking for a filter option. Is there a possibility to add a Filter to the SyncOrchestrator or do I have to add the filter to the SyncProvider? According to this: http://social.microsoft.com/Forums/en-US/uklaunch2007ado...
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 ...
Microsoft Sync Framework: Sql CE and sql 2008 with change tracking option. I am facing a problem, when i have a record inserted in sql CE and it needs to upload on sql 2008 with uploadonly direction. The server sync process gives clientInsertServerInsert conflict and it is impossible that server can add new row to this table. Anybody ...