Sync framework and Compact SQL : Do we need to change technology? RRS feed

  • Question

  • Hi Erik

    Our system include between one to 20 PCs (windows 7 or 8 ) on a local network, with one "main" data base and multiple "local" data bases on each "client" PC

    We chose MS SQL server as the "main" DB, and Compact edition as the "local" DBs

    We sync only one direction, from the Main DB to the local DBs, using sync framework

    We have around 10 thousand existing installations in the field and we plan to replace them during the next 2 years

    We already deployed and tested the system in some test sites, but we can still change the technology if needed

    My question is:

    Is microsoft planning to support compact edition with sync framework? when?

    I saw a similar question in one thread ("technology dead-end"), but your answers were "how large is your table?", "you can use this or that script", "microsft is not supporting but it may work under some conditions"

    although it is quite helpful on the short term, I ask for somethig else.

    I don't need hacks, I need commitment for long-term support for the technology.

    Thanks in advance


    • Edited by alon1970 Sunday, September 22, 2013 7:46 AM
    Sunday, September 22, 2013 7:44 AM


  • Hi,

    Note first, that I am not employed by Microsoft, I just help SQL Server Compact users.

    So I can make no commitments on behalf of Microsoft.

    You can see the support matrix for SQL Server Compact here: http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=SQL+Server+Compact&Filter=FilterNO - so how long support lasts depends on the SQL Server Compact version you use, since you use Sync Framework, I assume it is 3.5 SP2.

    Let me know if you need more info than this, and I will do my best to point you to public resources. Notice, that Merge Replication is fully supported with SQL Server 2012 and SQLCE 3.5 SP2. But that requires SQL Server Standard edition.

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    • Proposed as answer by Candy_Zhou Wednesday, September 25, 2013 1:28 AM
    • Marked as answer by Allen Li - MSFT Friday, September 27, 2013 7:53 AM
    Sunday, September 22, 2013 12:36 PM