Sync to the Web - Enable Offline Access to Web Data from any Data Store

Sync to the Web - Enable Offline Access to Web Data from any Data Store — Wed, 12 Mar 2008 04:08:40 GMT

PingBack from http://othercool.com/blog/2008/03/11/sync-to-the-web-enable-offline-access-to-web-data-from-any-data-store/

re: Sync to the Web - Enable Offline Access to Web Data from any Data Store

RathiSarov — Wed, 19 Mar 2008 14:28:15 GMT

Hi,

I would like to know if we can use SQL Server 2005 as the client and Oracle as back end for the data synchronization? If so, could someone please share the code?

Thanks,

Rathi

re: Sync to the Web - Enable Offline Access to Web Data from any Data Store

liamca — Thu, 03 Apr 2008 01:11:52 GMT

Hi Rathi,

Yes, you can use Sync Services for ADO.NET to access an Oracle back-end server. We do not yet have a client side provider for SQL Server 2005. If you were willing to use SQL Server Compact on the client side then this would work. There is a good example of this here:

http://blogs.msdn.com/synchronizer/archive/2007/03/09/demo-v-offlineapplication-oracle-backend.aspx

Alternatively you could use the Sync Framework to build two provider to talk between Oracle and SQL Server 2005. This would be a little more work on your part though than Sync Services for ADO.NET.

Liam