SQL Server Everywhere Edition: It's Coming!

[Jon Westfall]

<div class='os_post_top_link'><a href='http://msdn.microsoft.com/vstudio/default.aspx?pull=/library/en-us/dnvs05/html/sqleverywhere.asp' target='_blank'>http://msdn.microsoft.com/vstudio/d...leverywhere.asp</a><br /><br /></div><i>"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."</i><br /><br /><img src=http://www.smartphonethoughts.com/images/Kris-Aug06-SQLEverywhere.jpg><br /><br />SQL Server Everywhere edition looks poised to sweep down on third-party lightweight database products. With the availability of a MS solution to replace third-party, anyone seeing this product in the future for their development toolbox?

[topps]

SQL Server Everywhere edition looks poised to sweep down on third-party lightweight database products. With the availability of a MS solution to replace third-party, anyone seeing this product in the future for their development toolbox?

But with SQL Server CE, its predecessor, there was already an MS SQL product for mobile devices... so I don't think that this will be likely to make a difference to the third-party databases, any more than SSCE did.

That said, I am glad to see that they are continuing to develop SSCE or what they are calling it now. I hope that the changes are more than cosmetic.

[mgartner]

And what's the matter with desktop synchronisation like it's currently possible with PocketAccess?

[topps]

And what's the matter with desktop synchronisation like it's currently possible with PocketAccess?

PocketAccess is fine for individual use. The biggest difference that we found with using SSCE is that the smart sync of changes to a central database by multiple users is handled much better. You can have changes be propagated unidirectionally or bidirectionally. You can change the ability to modify the datatables depending on user access rights. All that kinda corporate big database stuff.

That might sound like overkill. For individual users wanting just to keep their own data tables sync'd, it is. But for those of using PDAs as a data collection tool across a broad group, the increased capability is very welcome.