Re: Good Books on SQL Server Mobile

Greg,

As far as I know, the only book out so far specific to SQL Server Compact Edition is Bill Vaughn's eBook: http://www.hitchhikerguides.net/EBooks/default.aspx Recent books on general mobile development topics also tend to have a chapter or two covering SQL Mobile.

There are also some good tutorials on developing for SSCE here: http://msdn2.microsoft.com/en-us/sql/bb219480.aspx

To answer some of your questions:

You do not have to use the Data Connections tools within VS. You can create databases programmatically, and you can also use SQL Server Management Studio to create SSCE databases, test querires, etc. I tend to use Management Studio during development while I'm designing the database, but my apps that use SSCE always have the ability to create those databases as needed by the time they're production ready. In most cases for me that's a desktop app that creates the database and pushes the data down to the device, but increasingly I'm using SQL Compact for purely desktop apps for local data storage.

For deployment, I copy the SQL Mobile cab file to devices in my installation/data extractor desktop app, but you can also just copy the SQL Mobile dlls you need along with your app. A formal installation isn't really necessary - just convenient for me.

--
Ginny


"Greg_H" <Greg.Harabedian@xxxxxxxxx> wrote in message news:1172247838.705197.272550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Can anybody recommend a good book on developing and deploying mobile
database applications using SQL Server Mobile? I am in the process of
trying to develop and database application and am a bit unclear on the
exact process of building and deploying a mobile database.
Specifically I want to know if I can build my mobile database with a
build script instead of going through the "Data Connections" within
VS2005. Also once a database is build on my workstation in my
development environment is there an easy way to deploy it to one or
more mobile devices? Also, is there an equivalent of "Query Analyzer"
that can be run against a SQL Server Mobile database on the
workstation/server as I am developing the database?

Thanks,
Greg


.

Relevant Pages

  • Re: Alternatives to SQL Server Mobile?
    ... Intellisync offers robust database sync between SQL Mobile, ... > However the app is NOT SQL Server based, ...
    (microsoft.public.pocketpc.developer)
  • Re: Good Books on SQL Server Mobile
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Management Studio during development while I'm designing the database, ... desktop app that creates the database and pushes the data down to the ... I copy the SQL Mobile cab file to devices in my ...
    (microsoft.public.sqlserver.ce)
  • Re: Alternatives to SQL Server Mobile?
    ... database extensively and was told by a colleague that DB2e was better. ... I must humbly disagree about DB2e. ... Intellisync offers robust database sync between SQL Mobile, ... >> However the app is NOT SQL Server based, ...
    (microsoft.public.pocketpc.developer)
  • Re: Good Books on SQL Server Mobile
    ... the only book out so far specific to SQL Server Compact ... mobile development topics also tend to have a chapter or two covering SQL ... desktop app that creates the database and pushes the data down to the ... installation/data extractor desktop app, but you can also just copy the SQL ...
    (microsoft.public.sqlserver.ce)
  • Re: Good Books on SQL Server Mobile
    ... the only book out so far specific to SQL Server Compact ... mobile development topics also tend to have a chapter or two covering SQL ... Management Studio during development while I'm designing the database, ... installation/data extractor desktop app, but you can also just copy the ...
    (microsoft.public.sqlserver.ce)
Quantcast