locked
Anything lighter than MSSQL express? RRS feed

  • Question

  • I've clients using Lightswith on laptops but running MSSQL is too heavy for their laptops. Is there any lighter alternative to MSSQL express?

    Second, is there a way to upload laptop data to MSSQL server or SQL Azure at later time?

    Thanks!

    Thursday, December 27, 2012 10:01 PM

Answers

  • Hi,

    you can store the data in simple database files. SQL Server CE is the name of libraries to access the data. But it is more limited regarding the possibilities and as far as I know there is no Lightswitch data provider that could be used.

    The synchronisation of the data is always a complex thing and should be planed carefully. (You have to solve conflicts in a useable way.) You could write a program that is doing the synchronisation. There is a sync framework available that could be used to get something like that quite easily:
    http://msdn.microsoft.com/en-us/sync/bb887608.aspx
    http://visualstudiomagazine.com/articles/2012/06/01/database-synchronization-with-the-microsoft-sync-framework.aspx

    I can understand the core problem: To have a Lightswitch Application up and running on an Laptop simply requires a lot of ressources: Database, Application Services and Silverlight client all need their part. A SQL Server CE solution completly written in C# or VB.Net might require much less ressources.

    With kind regards,

    Konrad

    • Marked as answer by Cruz2k13 Friday, December 28, 2012 8:58 PM
    Friday, December 28, 2012 10:14 AM

All replies

  • Hi,

    if you just run the LS Client on the laptop, then you do not need any database.

    If you want to run the whole application on the client then you can do that of course. In such a case SQL Server Express should be the smalest edition that you could use.

    Regarding the 2nd question: Do you need only a full upload or a full sync (sending changes inboth directions)? Can you describe what you have in mind?

    With kind regards,

    Konrad

    Thursday, December 27, 2012 10:06 PM
  • full sync. Basically, i want to make central db online and local laptop data to be sync'ed with that db.

    Another thing, I need to keep a local db because laptop is not connected to the internet all the time. But it is already using sql express and client is complaining about it. I was wondering there was other way to store the data locally then sync online.

    • Edited by Cruz2k13 Friday, December 28, 2012 9:42 AM
    Friday, December 28, 2012 9:38 AM
  • Hi,

    you can store the data in simple database files. SQL Server CE is the name of libraries to access the data. But it is more limited regarding the possibilities and as far as I know there is no Lightswitch data provider that could be used.

    The synchronisation of the data is always a complex thing and should be planed carefully. (You have to solve conflicts in a useable way.) You could write a program that is doing the synchronisation. There is a sync framework available that could be used to get something like that quite easily:
    http://msdn.microsoft.com/en-us/sync/bb887608.aspx
    http://visualstudiomagazine.com/articles/2012/06/01/database-synchronization-with-the-microsoft-sync-framework.aspx

    I can understand the core problem: To have a Lightswitch Application up and running on an Laptop simply requires a lot of ressources: Database, Application Services and Silverlight client all need their part. A SQL Server CE solution completly written in C# or VB.Net might require much less ressources.

    With kind regards,

    Konrad

    • Marked as answer by Cruz2k13 Friday, December 28, 2012 8:58 PM
    Friday, December 28, 2012 10:14 AM
  • Doesn't Azure SQL has some built in functionality to sync data?
    Friday, December 28, 2012 8:59 PM