SQL CE data transfer.

[tc]

Hi. I've got a mobile app that I'm upgrading from old CEDB technology to
Mobile SQL. VB2003 to 2005.

The only way I can find to transfer data to and from the mobeil device is
connecting to a server, sql, iis, etc. This is a problem as the system
doesn't use an sql or iis server, never will.

So, how do you transfer data easily between host and portable? I don't want
to export and import data as we're talking about a lot of data.

Also, are will still stuck with RAPI for transfering files or is there
anything else yet?

 

[Ginny Caughey [MVP]]

tc,

Rapi is generally the best way to transfer files between mobile devices and
PCs, but with SQL Mobile the file is actually usable once it gets on the
desktop. It's not that hard to write a desktop app to read the data in the
sdf file and do something with it. In the works are more sophisticated
approaches. One to keep you eye on is the Sync Services for ADO.Net which is
currently in CTP. It will eventually allow you to sync from any data source
with an ADO.Net provider to any other.

 

[Guest]

In addition to what Ginny suggested, you might consider using the SQL Server
Management Studio: http://msdn2.microsoft.com/en-us/library/ms174173.aspx

It allows you to directly connect to the sdf database on the device (when
device is cradled) and run scripts etc against it. Fantastic feature that we
use all the time.

The express edition is free to download but for mobile support I think you
need the professional edition. If you are an MSDN subscriber it will be on
the SQL Server 2005 DVD, or downloadable via the MSDN subscription web site.

 

[Ginny Caughey [MVP]]

Thanks, Simon. Beginning with sp2, the Express Management Studio also allows
you to connect to SQL Server Compact databases.

 

[tc]

Many thanks for your resonses, gives me something to get started with.

So, if I understand correctly the SQL database on the mobile is a single
file? If this is the case how does one write this file on the Host before
download to the mobile?

Cheers,
Tull.

 

[Ginny Caughey [MVP]]

Yes it's a single file and you can write it on the desktop machine and just
transfer it.