locked
Client Databases Supported RRS feed

  • Question

  • Hi

     

    I have been reading the Architecture and Classes documentation, which contains the following definitions

    Client Database

    The client database for Sync Services for ADO.NET applications is SQL Server Compact 3.5. Sync Services for ADO.NET provides an infrastructure to track incremental changes in the client database. This infrastructure is enabled the first time any table is synchronized by using a method other than snapshot synchronization.

    Server Database

    The server database can be any database for which an ADO.NET provider is available. If you want to track incremental changes in the server database, you must prepare the database to do this. For more information, see How to: Prepare a Server Database for Synchronization.

     

    Is it possible to have client databases other than SQL Server Compact 3.5, in particular SQLite?

     

    Regards

     

    Aidan

    • Moved by Max Wang_1983 Friday, April 22, 2011 9:46 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Thursday, November 8, 2007 11:42 AM

Answers

  • there is not a specific document for it at this moment. what you need to do is to implement the virtual method defined on the Syncprovider object and creaet your own tracking mechanism and your own way to store the metadata on the client db.

     

    Thanks

    Yunwen

     

    Friday, November 16, 2007 12:47 AM
    Moderator

All replies

  • Hi Aidan,

     

    Yes, you can synchronize to databases other than SQL Server Compact, however it means that you would need to create your own client provider as well as to create your own change tracking mechanism in SQLite.

     

    Liam

     

    Thursday, November 8, 2007 10:51 PM
  • Hi

    Thanks for the reply.

    Is there any documentation/howto to show and explain the steps involved in creating the client provider and the tracking mechanism.


    Aidan
    Thursday, November 15, 2007 10:00 AM
  • there is not a specific document for it at this moment. what you need to do is to implement the virtual method defined on the Syncprovider object and creaet your own tracking mechanism and your own way to store the metadata on the client db.

     

    Thanks

    Yunwen

     

    Friday, November 16, 2007 12:47 AM
    Moderator