Can I use SQL_Mobile as PC desktop server or PC local cache server?

Can I use SQL_Mobile as PC desktop server or PC local cache server

I want many data to be cached at user's PC,
and call for this data to be created transparently as for remote
main SQL server.

Is it possible to do without creating complex structure of doubling functionality
of main queries to single SQL server

some articles, samples, links, keywords

thanks you


Answer this question

Can I use SQL_Mobile as PC desktop server or PC local cache server?

  • Colonel Hogan

    SQL Server Mobile cannot be used on Desktop for production use. It is restricted by licensing terms.

    The next version of SQL Server Mobile known as SQL Server Everywhere is available for production use on Dekstop. The CTP of SQL Server Everywhere is at the following location - http://www.microsoft.com/sql/ctp_sqleverywhere.mspx The data can be cached in the user's PC in SQL Server Everywhere. The data can be replicated between SQL Server Everywhere and SQL Server by Merge or RDA Replication. Link to Replication is - http://msdn2.microsoft.com/en-us/library/ms171801(SQL.90).aspx

    Regards

    Ambrish



  • Can I use SQL_Mobile as PC desktop server or PC local cache server?