Batching support for Upload in Offline scenerio for Oracle database

• 10 noiembrie 2009 17:56

   

   
  

  0
  Hi i am developing the ocassionaly connected application with data sync capabality with the centeral oracle server.
  
  
  
  

  Hi i  am developing the occasionally connected application with data sync capability with the central oracle server. I am using the SQLCE as client side datastore & oracle as server side datastore with N-tier architecture with WCF service .

   

  Question 1 :Can i use the SQL express as the local side data store & is there any automatic schema creation support provided in the MSF2.0?

   

  Question 2 : With the RelationalSyncProvider  in collaboration mode , client can upload the data to server ( SQL<-->SQL )  , I wish to know  can I upload data from the client  with Oracle database as backend  in the Offline mode ? I guess not , I still need to use the generic DbServersyncProvider & i cannot take the advantage of memory based batching features for the upload from the client , please confirm.
  
  Question 3 : How can i take take the advantage of the memory based batching support with SQLCe ( Client side)  oracle backend  ( Server Side) with  N-Tier Architecture ?Is there any way to do that ?
  
  

  Thanks & regards
  MOhan
  
  

  • Mutat de Mahesh DudgikarMicrosoft Employee, Owner 23 noiembrie 2009 19:39 (From:SyncFx - General)
  • Mutat de Max Wang_Chinasoft 19 aprilie 2011 23:03 Forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
  •