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...
Hi, I am using SQL Server 2008 and the WebSharingAppDemo-SqlProviderEndToEnd sample and this is almost perfect for my needs however I am unable to detect conflicts. By default ConflictResolutionPolicy is set to ApplicationDefined. I have tried setting the ResolutionPolicy to SourceWins, DestinationWins or ApplicationDefined and I alwa...
We have a requirement very similar to that shown in the Occasionally Connected Application (OCA) diagram on the Introduction to Sync Framework Database Synchronization article. We can't however find any examples on how the clients at the bottom are syncing between each other. Particularly, how a smart device syncs with another client eac...
I am creating a WPF app that needs to allow users to work in a temporary disconnected state and I plan to use a Local Database Cache. My question's are about my data access layer. Do you typically create the whole DAL to point at the Cache or both and create a switching mechanism? Is Entity's a good way to go for my DAL against the ...
The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. P...
Unable to obtain a new server anchor. Make sure that you can establish a connection to the server database and that the SelectNewAnchorCommand property of the DbServerSyncProvider is specified correctly [4/14/2010 12:58:49 PM] Badar Muneer says: An error occurred while starting a transaction on the provider connection. See the inner exce...
I'm trying to use design a syncronisation application that syncs changes between different SQL Server databases. I came up with a design based around receiving the ItemConflicting event, storing the knowledge associated with the conflict, and resolving all conflicts off-line. However, it seems that I can only get the ApplyChangeFailed ...
We are implementing a warehouse management system atop an open source stack (Java, web services & friends). In this system, we want to integrate many mobile devices which should also be capable of adequate online/offline functionality, e.g. preparing database inserts while a mobile device is temporarily unconnected, and performing them o...
Hello, we are developing an application which uses MS Sync Framework to sync data between Windows CE 6.0 with SQL CE 3.5 SP1 Clients and an SQL 2008 Database. Our major problem is a slow sync time up to 1 minute for 15 tables which are totally empty. Here's a break down of our components: Server: Sql Server 2008 15 tables with activat...
Hello, We implementing offline feature to an existing application. We have implemented the syn with SQL Server internal change tracking and over WCF using MS Sync Framework (http://msdn.microsoft.com/en-us/sync/default.aspx) All of our tables have primary key as integer, we cannot move to GUID. So as you are thinking we will have id...
Hi All I'm trying to develop a custom sync provider to sync files over the internet using WCF service. We already have a file transfer service and it's working in production but I need to implement a custom sync provider on top of it. I've checked the solution in Braynt Likes blog here but this doesn't fulfill my needs. Any advices, g...
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 have one central SQL Server database which can be offline from time to time. I have a desktop application using Local DB Cache (SQL CE) to synchronize with the central database and I also have a web application with its own SQL Server that I'd also would like to keep synchronized. All synchronizations must be bidirectional. Is there a...
B"H If I setup a sync scope on two sql servers and syncing is working fine for a while? And then I need to change the schema for one of the tables. Lets say I need to add a column, or change the primary key. How do I go about doing this so that Microsoft Sync Framework still syncs that table properly? I assume that I run the change sc...
B"H What are the steps of keeping Sync Framework up to date with schema changes in the database? ...
I have already setup syncing with Microsoft Sync Framework, and now I need to add fields to a table. How do I re-provision the databases? The setup is exceedingly simple: Two SQL Express 2008 servers The scope includes the entire database Using Microsoft Sync Framework 2.0 Synchronizing by direct access. Using the standard new SqlSync...
Hi As far as I understand the Client Server Scenario (aka Offline Scenario) it is supposed to use with a SQL Server as Server and a SQL Server Compact as Client. I have to implement a synchronization between a master and several nodes where the nodes communicate and synchronize with the master but not with each other. Master and Nodes a...
Hi, Hi, I have a client winforms which creates xml-s with objects. Once a month I get this xml-s and save theirs in my database(a lot of columns, and fields). Now, I want to get this reports more often and omit serialization and deserialization. I'm only interested in Microsoft technology so if is it impossible to sync sql ce(in my ...
I currently have a highly customized synchronization solution which uses the Microsoft Sync Framework. The general architecture of the solution is that data is synchronized between 2 sites via a web service. The sites have different db schema, so everything is sync'd at an object level using custom Providers inherited from the Sync Frame...
I've got a central SQL server database. My solution has a WCF service responsible for synchronizing data with clients running SQL Server or SQL Server Express. The service uses Microsoft Sync Framework and it works well, but the Sync Framework requires a direct connection to my client's server, and clients that are running SQL Server Ex...