locked
SQL Server Compact, Silverlight 2, 600 gig databases, and the Microsoft Synch Framework RRS feed

  • Question

  • Hi,

     

    We are developing a Silverlight 2 application that is essentially a user management interface for a remote 600 gig database.  A good user experience is essential.

     

    We cannot download and synch a 600 gig database; however, there are many tables that change slowly that could be downloaded - for example, Countries, Companies, Reports, etc.  Many Combo Boxes will have 20,000 items - many data grids will have 200,000 records which must update and scroll with a very good user experience.

     

    In order to download 200,000 records we use serialized, compressed, binary proprietary protocol.

     

    In order to have a larger compact client local database, we need to increase the allowable size for local Silverlight 2 storage and we need to be able to download a SQL Server Compact database into this local storage area.  Our customers will agree to allow this but we don't know how to set it up and configure it.  We also do not know how to utilize the Microsoft Synch Framework as much as possible.

     

    We realize that this is a difficult issue (but we feel rather common for Silverlight LOB applications) and encompasses several different Microsoft technologies.

     

    Any help and guidance would be appreciated.

     

    Thank you,

    David

    Tmp@SoftwareByDavid.com

    • Moved by Max Wang_1983 Tuesday, April 19, 2011 6:17 PM Forum consolidation (From:SyncFx - Feedback [ReadOnly])
    Thursday, March 20, 2008 12:16 PM

Answers

  • Have you looked at the Sync Services for ADO.NET? This shipped with the Visual Studio 2008 and also ships with the Microsoft Sync framework. This may fit well with your scenario.

     

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

     

    I am reading that on the client you need about 200,000 rows of the 600GB server. How much data does that come up to?

    I also see that you are looking at the SQL Server compact as a client. It has certain limitations, so please look into that.

     

    And how many clients are you envisioning to have. If it is more like a hub-spoke scenario the above Sync services for ADO.NET will help with SQL Compact clients. On the other hand if you have SQL Express clients, then you can look at the sample (link below) and see if that is a proper fit for you.

    http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=1200

     

    Lastly if you are not talking about hub-spoke scenarios, but more like 2-3 clients and are looking at synching data between these clients, then you should look at the Provider services from Microsoft Sync Framework (DBpeerprovider) for doing peer-to-peer sync.

    Thursday, July 17, 2008 8:47 PM