We need to make our enterprise ASP.NET/NHibernate browser-based application able to function when connected to or disconnected from the customer's server. Has anyone done this? If so, how did you do it? (Technology, architecture, etc.) Background: We develop and sell an enterprise browser-based application used by construction field pe...
Can anyone tell me what version of the .NET framework (CLR and BCL) is req'd for the recently-released MS Sync Framework (for support of occasionally-connected-applications)? Its listed as Sync Framework V1 for ADO.NET v2.0 but none of its listed req'ments say anything about the .NET fx version that is required to support it. Anyone go...
hi there, i sync a database via wcf service to sql ce databases on my clients. however, i don't want the schema generated on the client side to be the same, as the one on the server. is there a way to customize the schema returned to the client syncproviders? ...
hi there, i`m using sql server ce together with sync framework. however, sync framework creates some system tables when calling the CreateSchema() method of the SqlCeClientSyncProvider. (e.g. __sysSyncArticle, __sysSyncSubscription, ...). i'm not able to delete these tables with sql statements within Visual Studio. (states that "drop ta...
I am looking for resources on Microsoft Sync Framework. Although MSDN and Google Search gave me the brief overview, I want some demos and presentations. Also, is Live Mesh based on Sync Framework? ...
We have an application that will be collecting data and storing it in local WinXP PCs using Microsoft SQL Server Compact. We want to aggregate that data up to a single full-blown SQL Server for reporting and archival. The data transport needs to be fairly continuous (i.e. not batched) though some latency is acceptable (a minute or two ...
Are you using it or plan to use it? ...
The regular code snippet of syncing data with sync framework is this: LocalDBSyncAgent syncAgent = new LocalDBSyncAgent(); Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize(); Do anynody knows a way to sync a subset of my tables. Note not the data inside each table but the decide which tables would be inv...
Hi All, I am planning to use the following architecture for one of the applications: Client: Java based application, which will use a MySQL database Server: Will be C# based and the database will be SQL Server Now is it possible to use Microsoft Sync Framework in Java? (Probably by implementing some interfaces?). I want the data from J...
We upload sales transactions from our stores to the headoffice server. At the moment, we use DTS (SQL Server Data Transformation Services), but we’re planning on replacing that with Microsoft Sync services for ADO.NET, as this seems to be Microsoft’s preferred solution for this type of setup and we want to follow the standard (that will ...
We are planning to use Sync Services for ADO.NET to sync stores with headoffice and it has been suggested that I sync via a WCF proxy. Does syncing via a WCF proxy mean that I will be able to sync over http? If not, is it possible to use sync services to sync via http. (I do not want to update our firewall every time we get a new store...
Hey guys, I want to ask if there is an equivalent to the @@DBTS TSQL global variable in MySql (I need to access the timestamp of the last row that has been accessed in the whole database, not just one table). I need this because I'm trying to use Microsoft Sync Framework and MySql for bi-directional syncing. Any help will be much appre...
I'm just working into the Microsoft Sync Framework. It looks quite easy to sync a local SQL CE 3.5 Database with a remote SQL Server 2008 using the SqlSyncAdapterBuilder and SqlServerChangeTracking. Unfortunately, syncing two SQL CE 3.5 Databases doesn't look that easy... The documentation is very sparse, and I don't realy know how to g...
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...
I'm using Sync Framework v1 (which includes Sync Services for ADO.NET v2) and Sync Services for mobile v1. I can sync a SQL Compact Edition database from a mobile device to SQL Express on a desktop PC. I can also sync a SQL CE database from a desktop PC to a SQL Server database on a web server using WCF. I want to sync from the mobil...
Does anyone out there find it useful to sync' SharePoint sets (lists, documents, etc.) with "external" sources like the file system? What about SharePoint-to-SharePoint sync? Do we have any explanation why Microsoft Sync Framework lacks any serious hooks into SharePoint? Is this stuff coming out in some Office 14 timeframe? Under NDA? ...
I have the option of either using WCF or Microsoft Sync Framework for my next project. This will be a SQL Server backend that needs to sync to a mobile (.net cf) front end. I have a few issues, 1. the database schemas between the two databases will not be the same. 2. On the server side I actually need to call a .net dll to do the upda...
Possible Duplicate: Advantages and disadvantages of GUID / UUID database keys Are there any circumstances where it is essential to use GUIDs as primary keys in a SQL Server 2005/8 DB. For example, does the use of the MS Sync Framework force this, or data replication? ...
In order to provide heterogeneous synchronization between devices, have you ever used Mesh4x ? It uses FeedSync to synchronize data. http://code.google.com/p/mesh4x/ ...
Hi, Hopefully someone can help me. I have a Visual Studio 2008 WinForms application to which I have added a Local Data Cache. The local data cache is using a SDF file via SqlServerCE and is caching a SQL Server 2008 dbase with change tracking enabled. This is working and I can do bidirectional syncs and the like. The problem I am ...