Export / Import using Sync and SqlCompact RRS feed

  • Question

  • Hi !

    I already have a WinFormApp that uses a "SqlCompact 3.5 SP1".
    1- Can I use Sync framework to implement a feature to "Export / Import to a SDF File"?

    Taking the "Northwind.Sdf" as a database sample, I want Export and Import my Orders and OrdersDetails to another SDF File.
    2- Is it possible using Sync Framework?

    Thanks in advance for any tip!

    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:46 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Saturday, October 31, 2009 7:51 PM


  • Hi,

    If your orders and ordersDetails tables are in a SQL Server or SQL CE database, and you want to replicate them to another SQL CE database, you can use SqlSyncProvider and SqlCeSyncProvider to sync the tables from one database to another. Additional metadata tables will be created in both database if you pick sync solution to do so. Please consider if it is what you want. For more details, you can take a look of the code sample "Database Sync: SQL Server and SQL Server Compact" in http://code.msdn.microsoft.com/sync.

    This posting is provided AS IS with no warranties, and confers no rights.
    Monday, November 2, 2009 9:49 PM