I want to realize an offline scenario where client and server are SQL Server databases. Preferably with SQL Server Change Tracking. Is that possible and a reasonable option at all? From trying out it seems to me the only sql server to sql server sync is in collaboration mode and doesn't leverage sql server change tracking. (SqlSyncProv...
Hi, Using microsoft sync framework 2,is there a way to sync all tables between two ms sql 2008 databases, with out specifically adding each table to a scope? Thank you! ...
I am looking at sync frameworks for a project I'm going to work on. I will be syncing two server file systems together. I have looked over Microsoft Sync framework and now Funambol. Does anyone have any opinion on Funambol? ...
Our WCF web services are not being consumed by any other service, and we highly doubt that they will be. Currently we are only loading about 30 5k objects and have been using web services with success. At this point we are looking at scaling this to support 1,000 objects. Only about 20 will change at any one time. We have a few options...
Hi I'm building an application that runs on a Windows Mobile device. I'm using Microsoft's Sync Framework to sync the Sql CE database with the main corporate db. The question is how can I limit the fields that are syncronized? The table in question has stacks of fields but I only need to display a few of them on the mobile device and ...
I'm looking for anything that facilitates syncing local data with some server on the internet. It doesn't have to be as mature as those two and any platform is fine, I'm just looking at different approaches to the problem. ...
I'm trying to mock a class from the Microsoft Sync Framework. It only has an internal constructor. When I try the following: var fullEnumerationContextMock = new Mock<FullEnumerationContext>(); I get this error: System.NotSupportedException: Parent does not have a default constructor. The default constructor must be explicit...
Hi I'm trying to create a new "Local Database Cache" item in Visual Studio 2010 to sync against a local Sql Server Express 2008 R2 database. When the wizard pops up though the "Use SQL Server change tracking" checkbox is disabled. Any ideas? I tried running ALTER DATABASE MY_Database SET CHANGE_TRACKING = ON but that had no effect. ...
I'm using the Microsoft Sync Framework version 2 to synchronize data between a server database running SQL Server 2008 and a SQLCE 3.5 database on an occasionally connected WPF app. This is working fine for the most part, but rows from a particular table don't seem to be getting pushed back up to the server database when inserted on the...
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 Similar questions have been asked before but after a day of going through the answers I'm still very confused. I'm using Microsoft's Sync Framework with SQL2008 on the server and SQL CE on Windows Mobile devices. I would have thought this was a VERY common requirement. I don't want to replicate large tables onto the mobile device....
I have an app that uses SQL Enterprise to store all data in 4 different DB's. I needed to build in the ability to work "offline" for my users. I accomplished this through Merge Replication to local SQL Express installs for everyone. This "Works" but feels like the sledge hammer approach. For instance, I am replicating all 14000 peo...
I'm fairly new to the MS Sync framework and have been beating my head against the wall for about four hours now to no avail. I'm simply trying to sync my databases (one "master" SQL Server 2008 with a SQL Server CE, the client) with: Dim syncAgent As DataCacheSyncAgent = New DataCacheSyncAgent() Dim syncStats As Microsoft.Synchronizati...
Hi, I am looking for SQL Azure specific provider that seems to be published by Microsoft. I downloaded the sync tool given at http://www.microsoft.com/downloads/details.aspx?FamilyID=bce4ad61-5b76-4101-8311-e928e7250b9a&displaylang=en but it contains a sync wizard. I need to implement a lot of custom synchronization logic to synch...
Hello, I've got the following scenario: In my system, it is possible that two data-stores (both SqlCe, or one is a server) will have different sync-scopes defined. In these circumstances, can I sync the two databases? If it is possible to sync them, which scope will be used? Thanks, Assaf. ...
is there any configuration that I need to do to have a successful sync where my site has SSL certificate? you see i have a windows application that using WCF to sync data from my local database to the server database. Previously the site has no SSL certificate so it was name like this "http://www.example.com". The sync was working that ...
Hi, I'm trying to sync two SqlCe database with Sync Fx 2.1. I provisioned the source, then copied it (via Windows Explorer) to a target db. I tried to sync the two using the Sync Orchestrator, and got DuplicateNameException, with the following message: "A column named '__sysTrackingContext' already belongs to this DataTable." I can't ...
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...
I have ado.net sync services working on a mobile device. It does a snapshot sync over WCF (i used the .sync wizard stuff) and I have no problems. My problem is when I generate scripts from the database so that I can create it else where that DB does not work with sync. I get a TargetInvocationException when it does its GetSchema call. Th...
I have a SQL Server 2008 database that contains DateTimeOffset objects. As per this page, SQL Server Compact provides support for replicating the new data types in SQL Server 2008 such as date, time, datetime2, datetimeoffset, geography, and geometry. The new data types in SQL Server 2008 are mapped to nchar, nvarchar, image, etc. F...