TechEd 2004 Europe coverage : SQL Server 2005 Mobile Edition alias SQL Mobile alias SQL Server CE 3.0 alias Laguna
July 02, 2004 [General] | By Edward J. R.
We just participated in an interesting session with Kevin Collins as a speaker:
... who used all forms of word "cool" when talking about this latest mobile product from Microsoft: "it's cool", "it's cooler", "I am working on SQL CE since 1996 but it is the coolest thing", "isn't it cool?", "total coolness in productivity", etc etc.
What is SQL Mobile? It is a successor to SQL CE database. But it is not just linear extension, but a whole revolution in mobile databases! Here are some highlights of the features of SQL Mobile that we learned from Kevin's session:
- to be embedded in ROM of Microsoft Smartphone too, not just in Pocket PC ; runs also in Tablet PC, so that developers can reuse the same database related code without changes; for Pocket PC 2003 and Tablet PC available now as beta and soon in full version, for Microsoft Smartphone coming in next version of Smarthpone OS (after 2003 Second Edition).
- wireless synchronizing possibility through Internet over HTTP with Microsoft SQL Server
- the data during synching is compressed - to speed up transfers; during demonstratio synching over GPRS between Pocket PC phone and SQL Server in USA took 30 seconds.
- multi-user support - possibility to access the same database engine from more than one GUI at the same time
- much much faster with plenty of optimizations, showplans and query optimization hints
- data designer support in Visual Studio 2005 so that no more maual coding is required
- data base in device can be managed with "Microsoft SQL Server Management Studio" remotely through ActiveSync connection ; "managed" meaning : changing database structure, adding optimization hints
- full access to SQL Mobile availble from managed code (i.e. .NET)
- very close integration with Visual Studio 2005 - even possibility to edit, within Visual Studio 2005, data that is located in a SQL Mobile database on the device!
- free redistribution but will require registration to get redistribution license
 Post your comment (free registration is required to post, but if you register you can edit your posts later)
 
|
|
Mobile Windows News | 
Podcasts | 
Database | 
Store | Search | Forums | Site News
