|
|
 Mobile Windows News |  Podcasts |  Videos | Search | Forums | Site News |
|
For developers: new article about successor to SQL Server Mobile - the SQL Server Everywhere August 09, 2006 [General] | By Edward J. R. First there was SQL CE, then came SQL Server Mobile (that is current contemporary version) and soon the SQL Sever Everywhere is coming, that will replace SQL Server Mobile and add some features by the way. As name indicates database applications will be executable not just in mobile devices, but everywhere: Introduces SQL Server Everywhere Edition, a slimmed-down version of SQL Mobile. SQL Everywhere removes the restrictions that keep the SQL Mobile product from running on a desktop or laptop, making SQL Everywhere the ideal, lightweight database for many scenarios. Microsoft recently announced that it will be evolving the SQL Mobile product into a product named SQL Server Everywhere Edition. SQL Mobile is currently a database that you can use on "mobile" devices, which include Tablet PCs, Pocket PCs, and Smartphones. SQL Mobile differs from SQL Server in that with SQL Mobile, there is no "server" running as a background process. The engine for SQL Mobile consists of a handful of DLLs that you reference from your application. When you want to connect to a database, you just put the path to the database file in your connection string. In fact, working with SQL Mobile feels a lot like working with an Access/Jet database. The limitation for SQL Mobile, today, is that it will only run on "mobile" devices. In other words, you can't deploy an application that uses SQL Mobile to desktops or laptops. SQL Everywhere seeks to take the SQL Mobile product and remove the restrictions that keep it from running on a desktop or laptop. This would make SQL Everywhere the ideal database for many scenarios. In many instances, desktop applications require significant amounts of local data storage. For example, take an application like Microsoft Money. It's a desktop application that sits on top of a database containing years' worth of your financial information. Think of Outlook. Again, it's getting its information from a server, but once the e-mails have been retrieved from the server, they're stored locally. For me personally, I've stored about 5 GB of archived e-mail, split across 4 "database" (Outlook PST) files. To read this article for developers about SQL Server Everywhere, click here. Early version (not even alpha or beta - just technical preview) of SQL Everywhere is available for download here, but if you do some production projects with mobile databases obviously you should use the contemporary variant - SQL Server Mobile 2005.  Post your comment (free registration is required to post, but if you register you can edit your posts later) [ 1 Comment ]
   |
| ||||||
| Mobile Windows News | Podcasts | Videos | Search | Forums | Site News |
