Hello, we are trying to get the Microsoft SyncFramework running in our application to synchronize an oracle db with a mobile device. Problem The queries that we need to gather the data on the oracle db take much time (and we haven't found a way to speed them up yet), so we try to split them up in as much portions as possible. One big p...
Hi any tip about building a custom sync provider that works through webservices (no WCF) ...
Microsoft Sync Framework with SQL 2005? Is it possible? It seems to hint that the OOTB providers use SQL2008 functionality. I'm looking for some quick wins in relation to a sync project. The client app will be offline for a number of days. There will be a central server that MUST be SQL Server 2005. I can use .net 3.5. Basically the cli...
Hi, Our central database is to be synchronized in a hub & spoke fashion. We need to be able to partition the data in a way that client data is replicated locally only to that client. Has anyone faced this problem? MSF provides sync scopes - declarations of tables are to be sycned, with the option to specify a filtercolumn and filter ...
I'm currently designing a smart client app (WPF) which needs to operate in an "occasionally disconnected" mode. For the offline scenario, I'm looking at using: Disconnected Service Agent Application Block (from the Smart Client Software Factory) Microsoft Sync Framework I should mention that I want my smart client app to be XCOPY-de...
What is deference between Microsoft Sync Framework and Replication? which one is better? ...
I've tried to get a solution for the above said question from MSDN Social and other resources from Microsoft. I was specifically looking for offline scenarios where client come online only to fetch updates from the Server. There are plenty of articles on Sync covering Sql CE but MSFT team seems to be ignoring questions from the communi...
We are analyzing Microsoft Sync Framework for syncing the client and server database. The scenario is like this: Server DB hold master data for all projects but the client DB only contains data to a specific project. Moreover the schema of client and server database is also different. However the data is easily convertible. Is there a...
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 ...
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? ...
I am trying to use Microsoft Sync Framework for syncing 2 SQL Server 2005 database (server and client). There are multiple tables in the database with lots of foreign key relation between them. I am using SyncOrchestrator to synchronize the two databases. string clientConnectionString = "<connection string>"; string serverConnectionStri...
Hi, We have started prototyping with the sync framework...I would like to know if / how we can use encryption, authentication and compression... Are we limited to using ssl in wcf or are there other possibilities...also would like to know if compression or authentication is possible and how? Any links with examples great... I am pres...
I was just wondering what is the best practice to perform dynamic filtering on Master-detail tables? consider the following scenario, i have 2 tables Order and OrderDetail I have created a filter (county 'WA') on the parent (Order) table; I would like to bring back only the Child(OrderDetail) that are related to the filtered parent re...
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...
We have an implemented a WCF service for sync framework communication with the guidance of http://wcfguidanceformobile.codeplex.com/ . The client in created by NetCFSvcUtil. We have run into a problem when web proxy support is needed. How can you enable credentials with it? On the HttpTransportBindingElement we can set the proxyadre...
We are looking at hosting our client's data on our own system and using the MS Sync Framework to replicate data with a SQL Server instance on each client's site. Each client might have on average about 500MB of data and there could be up to 1,000 client sites, se we would have about 500GB of data overall. Data changes will need to be rep...
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...
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? ...
I've stuck with syncing a Sql server 2008 having changes tracking enabled with a 2005 one that doesn't have this mechanism. Would you please point me a right track, how can I handle this. Thank you, ...