locked
How to collect data from multi SQL server compact edition database? RRS feed

  • Question

  • we need to create application to collection/mange data from multi-instruments which use SQL server 2008 compact editon database.

    We find the Sync Framework on MSDN site:

    http://msdn.microsoft.com/en-us/sync/bb736753.aspx

    Is the Sync Framework the best choice for the application?

    Are there other ways to achieve the same goal? Thx!


    JaneC


    • Edited by JJChen Tuesday, June 19, 2012 6:07 AM
    Tuesday, June 19, 2012 6:06 AM

Answers

  • you have other options like SQL replication, SSIS, custom ones...

    what's the client platform, connectivity, sync direction, custom processing for your sync requirements?

    • Marked as answer by JJChen Friday, June 22, 2012 3:50 PM
    Tuesday, June 19, 2012 7:59 AM

All replies

  • you have other options like SQL replication, SSIS, custom ones...

    what's the client platform, connectivity, sync direction, custom processing for your sync requirements?

    • Marked as answer by JJChen Friday, June 22, 2012 3:50 PM
    Tuesday, June 19, 2012 7:59 AM
  • JuneT,

    thanks for providing more information for us.

    Our client platform is microsoft embed windows.

    Syn direction is possible bidirectional synchronization.

    when you mention "custom processing" what do you mean?

    when you mention "connectivity", do you ask the application is always connection or some time offline? 

    We see the following link which comparing the sync framework with other Technologies (Remote Data Access(RDB), and Merge replication):

    http://msdn.microsoft.com/en-us/library/bb902818(SQL.110).aspx


    JaneC

    Tuesday, June 19, 2012 4:18 PM
  • by custom processing, i mean applying some business rules before applying the changes during sync, custom conflict handlers, etc...

    by connectivity, i mean is it via LAN, 3G, unreliable networks, firewalls/dmz, etc...?

    sync fx can definitely sync your data from SQL compact dbs to a central SQL Server, SQL Express, SQL Azure or even another SQL Compact DB.

    and so does SSIS, Service Bus, Replication etc...

    so have a look at all other stuff and see which one fits your environment.

    Wednesday, June 20, 2012 8:45 AM
  • JuneT,

    Thanks for clarification!

    From the link

    Architecture and Classes for Client and Server Synchronization

    : http://msdn.microsoft.com/en-us/library/bb726025.aspx

    we see that the client side always use SQL server database (may be SQL server expression, SQL server compact editon). Server side may use any server database for which an ADO.NET provider

    Is it true that client side must store data in the SQL server database in order to use Sync Framework?

    Our application later may need to support other applications which use XML as data storage in the client side.

    Can we still use Snyc Framework if data is stored in XML in client side? Thx!


    JaneC



    • Edited by JJChen Wednesday, June 20, 2012 4:36 PM
    Wednesday, June 20, 2012 4:28 PM
  • sync fx works with concept of providers. data sources need to have a provider.

    right now there are two sets of database providers, the offline providers and the peer-to-peer/collaboration providers.

    the former is the same one used in the VS Local Database Cache Wizard and OOTB only works with SQL Ce on the client and SQL Server on the server side.

    the latter has providers for SQL CE, SQL Express/Server/Azure and since its peer-to-peer, you can mix and match them.

    if the database platform has no OOTB support, that means you will have build your own.

    so to answer your question if there is an XML provider, the answer is no.

    Thursday, June 21, 2012 2:18 AM
  • JuneT,

    What does OOTB mean in the context? Search in Google, it means "Out of Box".

    If we need to support both SQL server Ce and XML storage, which tool is better for us?

    In other way, is there any tool could help us achieve both storages? Thx!


    JaneC

    Thursday, June 21, 2012 5:40 PM
  • OOTB = out of the box

    cant really recommend the best tool given the limited information on what you want to build.

    from a sync fx point of view, i can always tell you to load the xml to sql ce and sync the sql ce, but that may still be not the best solution.

    i can tell you to use ssis, but if you're client has no SQL server, that means you will have to dump the xml and sql ce databases where ssis can pick them up.

    i can also tell you to write a custom app to read  xml/sql ce databases and send messages to a service bus.

    Friday, June 22, 2012 6:52 AM