Database Sync: Oracle and SQL Compact 2-Tier

This application demonstrates how to use Sync Framework 2.0 database synchronization providers to configure and execute peer-to-peer synchronization between an Oracle database and one or more SQL Server Compact databases. What is Demonstrated in This Sample:*Using DbSyncProvider

C# (76.3 KB)
3,352 times
Add to favorites
E-mail Twitter Digg Facebook
Sign in to ask a question

  • MySql Script Equivalent
    1 Posts | Last post March 25, 2013
    • Hi Gary,
      Thanks for the solution, it was very helpful! However, I am considering using this framework to synchronise a MySQL database rather than an Oracle one. Do you by any chance have a script I could run and replicate the setup for a MySQL database?
  • Run the sample app?
    1 Posts | Last post March 24, 2012
    • Run the sample app and pass in an Oracle connection string as a command line argument.??????????????????????????????????????????????????????????????????????????????????????????
  • ?
    1 Posts | Last post March 24, 2012
    • You must have the Oracle client libraries installed. HOW?
  • Which database?
    1 Posts | Last post March 24, 2012
    • Do i have to create a new database (chema) or use one of existing ones?
  • Does this actually work?
    1 Posts | Last post May 09, 2011
    • Has anyone been successful in getting this demo to run? After following the instructions the Oracle XE DB is all set, the application builds correctly, and I can add data to either client or server. However, when I attempt to synchronize I get:
      Caught exception while getting changes: Microsoft.Synchronization.Data.DbSyncException: Cannot read scope information for scope sales. Ensure that the scope name is correct and the SqlCeSyncScopeProvisioning.Apply method was called to create that scope.
         at Microsoft.Synchronization.Data.DbSyncScopeHandler.ReadScope(IDbConnection connection, IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)
         at Microsoft.Synchronization.Data.SyncScopeHandlerBase.ReadScope(IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)
         at Microsoft.Synchronization.Data.RelationalSyncProvider.GetChanges(DbSyncScopeMetadata scopeMetadata, DbSyncSession DbSyncSession, UInt32 memoryBatchSize)