SQL Mobile

  • Thread starter Thread starter Chris Botha
  • Start date Start date
C

Chris Botha

I don't have VS 2005 Beta yet, but will soon. Meanwhile I need a link to
good documentation on SQL Mobile, or is it called SQL CE2?
In particular I am interested in if the database can be created on the
server and then transferred to the device.

Thanks.
 
U¿ytkownik "Chris Botha said:
I don't have VS 2005 Beta yet, but will soon. Meanwhile I need a link to
good documentation on SQL Mobile, or is it called SQL CE2?
In particular I am interested in if the database can be created on the
server and then transferred to the device.
Click to expand...

As i know, such feature will be possible in MS SQL server 2005
 
SQL Server 2005 Mobile Edition would correspond to SQL CE 3.0, but it
is usually referred to as just 'SQLMobile'. SQLMobile database is targeted
at all
mobile clients from smart phones all the way to tablet pcs, so Microsoft
dropped the 'CE' suffix.

Yes, you can create a SQL Mobile database on the server and transfer it to
device. You can also setup subscriptions in the database while it is still
on
the server and then transfer it to device. Very cool.

Your best bets for info are here:
http://www.microsoft.com/sql/ce/mobility/beta1.asp
and to obtain a copy of VS2005Beta2 or SQL Server 2005 April CTP. The MSDN
doc
that comes with these releases has good coverage of SQL Mobile.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
 
Chris,

SqlCE 2 is the current shipping version. SQL Mobile is the next version that
is in beta. In addition to VS 2005 beta 2, SQL Mobile should also be in the
current beta of SQL Server 2005. It's definitely worth a look when you do
get the beta.

SQL Mobile does allow you to create and manage its databases on the desktop
from SQL Server 2005 Workbench and also from the very cool new data tools in
VS 2005, but you can't write a desktop app to create a SQL Mobile database
and/or populate it with data from what I understand. For that you'd still
need to use merge-replication or RDA as with SqlCE 2.

Ginny Caughey
..NET Compact Framework MVP
 
What do I need installed on the server to create the database there? SQL
Server full version? The Express version? Does anyone have any samples?

Thore Berntsen
 
Thore,

As far as I know you'd need the full version of SQL Server 2005 for SQL
Workbench, and you'd also need the full version of SQL Server to set up the
replication publication that SQL Mobile would subscribe to.

Ginny Caughey
..NET Compact Framework MVP
 
but you can't write a desktop app to create a SQL Mobile database and/or
populate it with data from what I understand. For that you'd still need to
use merge-replication or RDA as with SqlCE 2.
Click to expand...

That exactly what I need... what good will the 2005 versions do??
 
Back
Top