Good Books on SQL Server Mobile

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg_H - 23 Feb 2007 16:23 GMT

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

Reply to this Message

William (Bill) Vaughn - 23 Feb 2007 16:51 GMT

I have written an EBook on the subject that might help. See
www.hitchhikerguides.net for more information.
It covers creating databases and populating the schema in a variety of
ways--including a build script. I include an example class that can
substitute for the (missing) SQLCMD utility.

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

> Can anybody recommend a good book on developing and deploying mobile
> database applications using SQL Server Mobile? I am in the process of
[quoted text clipped - 10 lines]
> Thanks,
> Greg

Reply to this Message

Greg_H - 25 Feb 2007 07:46 GMT

Just purchased your EBook Bill! Thanks very much for the tip.
Greg

Reply to this Message

William (Bill) Vaughn - 25 Feb 2007 20:40 GMT

Be sure to register on the support site and ask any questions you have. I
get notified the instant anyone posts a question.

Signature

> Just purchased your EBook Bill! Thanks very much for the tip.
> Greg

Reply to this Message

Alex - 15 Mar 2007 06:53 GMT

Hi Bill

I am one of them old guys who still programs in C++... Is that book
discussed also addressing only the lucky ones... (C# / VB) or does it also
have examples in C++

Cheers
Alex

> I have written an EBook on the subject that might help. See
> www.hitchhikerguides.net for more information.
[quoted text clipped - 16 lines]
> > Thanks,
> > Greg

Reply to this Message

William (Bill) Vaughn - 16 Mar 2007 06:18 GMT

Only VB.NET. It's the 20th or so language I've had to learn over the last 3
decades or so.

Signature

> Hi Bill
>
[quoted text clipped - 25 lines]
>> > Thanks,
>> > Greg

Reply to this Message

VJC - 11 May 2007 12:31 GMT

Hello Alex,

For the last couple of weeks I have been trying to mash SQL Compact Edition
into an existing application. I have found the articles on
http://www.pocketpcdn.com which shed some insight into the C++ OLEDB
interface.

The author uses the ATL OLEDB consumer templates to abstract out some of the
complexities of COM programming. Things will clear up once you scratch your
head for two weeks (ha).

The examples have been added upon over the last couple of years, alongside
the development of SQL CE. Even though the examples reference SQL CE 2.0,
minor modifications will allow the examples to work properly.

Hope this helps,
Vernon

> Hi Bill
>
[quoted text clipped - 4 lines]
> Cheers
> Alex

[snip]

Reply to this Message

Ginny Caughey [MVP] - 23 Feb 2007 16:56 GMT

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.

Signature

Ginny

> Can anybody recommend a good book on developing and deploying mobile
> database applications using SQL Server Mobile? I am in the process of
[quoted text clipped - 10 lines]
> Thanks,
> Greg

Reply to this Message

Alex - 15 Mar 2007 06:51 GMT

Hello Ginny,

Long time no speak, but I hit the wall again... The link with example you
are pointing us to, has only VB / C# ... Is that book discussed also
addressing only the lucky ones... or does it also have examples in C++

Cheers
Alex

> Greg,
>
[quoted text clipped - 38 lines]
> > Thanks,
> > Greg

Reply to this Message

Ginny Caughey [MVP] - 15 Mar 2007 22:42 GMT

Alex,

As far as I know the examples are all in managed code. Using C++ you'd be
using the OleDb adapter but I don't know of any books that cover that
specifically.

Signature

Ginny

> Hello Ginny,
>
[quoted text clipped - 55 lines]
>> > Thanks,
>> > Greg

Reply to this Message

Alex - 19 Mar 2007 21:47 GMT

Hi Ginny,

I was afraid this will be the response... Anyway thanks for te feedback.

I posted on 3/14 a question on the site titled "Using Seek / Ole DB with
C++" and got no feedback, I hope you can help me find an answer for this one.

Thanks
Alex

> Alex,
>
[quoted text clipped - 61 lines]
> >> > Thanks,
> >> > Greg

Reply to this Message

William (Bill) Vaughn - 19 Mar 2007 21:54 GMT

Consider that the types of tools, compilers and applications that MS writes
are not really "business" applications like most people write. While much of
that code is in C++ and now managed C++, the vast majority of the code
written out there is VB6, VB.NET, C# or Java at this point in time. That's
where the documentation and examples focus--on the mainstream business
development languages. It's expensive to write multiple versions of the
examples and oftimes prohibitively so. Since most C++ devs I know are
multi-lingual, it's never really been a serious issue.

Signature

> Hi Ginny,
>
[quoted text clipped - 81 lines]
>> >> > Thanks,
>> >> > Greg

Reply to this Message

Arcane Code - 25 Apr 2007 23:33 GMT

Thread's a tad old, but thought I'd point out in the book "Programming SQL
Server 2005" there's a chapter on SQL Server Everywhere Edition, which is
what SSCE was briefly known as during the beta days. It's pretty basic but
good for a quick start.

From an overall perspective though, Bill's book does a much more through
job. Still won't help you from the C++ side though, sorry.

Robert
http://arcanecode.com

> Can anybody recommend a good book on developing and deploying mobile
> database applications using SQL Server Mobile? I am in the process of
[quoted text clipped - 10 lines]
> Thanks,
> Greg

Reply to this Message