SQL Server Mobile Edition & C#

[Guest]

Hi ,

Perhaps this is the wrong place for this post but it seemed to fall between
several stools.

At the moment we create SQL CE databases on the PDA programmatically.

With the release of SQL Server 2005 (Yukon) you will be able to create
and modify SQL Server Mobile databases using the SQL server GUI.

Does anyone know will you be able to programmatically create modify ,
populate SQL Server Mobile databases on the desktop ?

Thanks,

DD

 

[Chris Tacke, eMVP]

For development purposes there will be a tool for modifying/querying mobile
databases on the PC.

-Chris

 

[PeterB]

But not creating? Or is that considered to fall under modifying?

You also say for developing...

Let's say I have an application using Sql 2k server. I want this app to be
able to create the sdf file (on the desktop) and send it to the PDA. Are you
saying this won't be possible?

I have tried to sort out if I _must_ have SQL Server 2005 or if I can create
..NET applications in C# that can export data from a SQL 2k server and create
an SQL Server Mobile file from it (sdf).

/ Peter

 

[Ginny Caughey [MVP]]

My understanding is that the answer is Yes, provided that the SQL Mobile
database files you create, modify or populate on the desktop are then copied
to a CE device (either using Rapi or by copying onto a storage card). If you
are targetting TabletPCs you'll also have the option of using the SQL Mobile
files on those desktops as I understand it. Personally I think it would just
be easier for Microsoft to just say Yes and be done with it, but I think
they want to make it clear that SQL Mobile files aren't a replacement for
MSDE or SQL Express on the desktop.

 

[Ginny Caughey [MVP]]

Peter,

I think what you want to do will be ok from what I understand.

 

[PeterB]

And if I have an application on the PC that is developed using Delphi 6, it
can call a library I developed in C# (VS 2005) to create an sdf file?

/ Peter

 

[Ginny Caughey [MVP]]

Peter,

Sorry but I am not familiar enough with Delphi 6 to answer. Certainly you
could do this with a .Net version of Delphi.

--
Ginny Caughey
..Net Compact Framework MVP

 

[PeterB]

Ok, that's what I thought...

Thanks Ginny!

/ Peter