Re: Sql Mobil (SqlCE 3.0) and Full Framework
- From: "Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx>
- Date: Fri, 23 Dec 2005 20:48:11 -0500
Ader,
For starters, make sure you try SQL 2005 Management Studio against your SQL
Mobile database. (You can target a local instance on your desktop computer
or one on an Activesync-connected device.) You can do most of the things
you're used to doing with regular SQL Server using Management Studio such as
queryies, analyzing query plans, defining and refining the database, etc. Of
course features like stored procecures an triggers which aren't supported by
SQL Mobile won't work.
Programmatically, you target SQL Mobile in your desktop app just as you
would on the device *except* you bring in a reference to the desktop version
of SqlServerCe.dll. When you create a desktop app and you select Add
Reference from Visual Studio, the correct version of Microsoft SQL Mobile
should be listed for you in the Add Reference dialog on the .NET tab and not
the one for mobile devices. Give it a try and let me know if you have
problems finding the right DLL - but I'll probably off-line for the next few
days.
--
Ginny Caughey
..NET Compact Framework MVP
"gonzalez" <none@xxxxxxxxxxxxxx> wrote in message
news:OJmkU8ACGHA.2912@xxxxxxxxxxxxxxxxxxxxxxx
>I understand that, and I don't plan to deploy it to a desktop due to
>licencing limitations... My only interest is
> to be able to build and troubleshoot the database on the desktop. We have
> a complex requirement to build
> a large SqlServer DB, but in order to be able to fit it on the PPC, we
> need to transform it to reduce it to a
> manageable size, and just put just the info the user needs on it, that
> would be done on our server backend,
> and then the sql ce db will be deployed to the Pocket PC device where it
> would be used.
>
> Can you tell me how I can use the full framework? the SqlServerCe ADO.Net
> provider doesn't work on the desktop.
>
> Thanks Ginny,
> --Ader.
>
> PS.
> I'm currently using replication to build the db manually, but to get the
> DB to a manageable size, I have drop all the rowguid id's and replication
> related tables before we ca put it on the device or it won't fit on most
> of our user devices. And the current process it's a pain, so I'm looking
> for a way to automate it either with my own server tool (full framework)
> or using SQL IS (DTS) services.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in
> message news:OOTlAFACGHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
>> Ader,
>>
>> In order to use SQL Mobile with .NET 2.0 on the desktop, you must either
>> be running on a development machine or on a TabletPC. It's not available
>> as a normal client database except on TabletPC operating system.
>>
>> --
>> Ginny Caughey
>> .NET Compact Framework MVP
>>
>>
>> "gonzalez" <none@xxxxxxxxxxxxxx> wrote in message
>> news:e3kmqg$BGHA.1032@xxxxxxxxxxxxxxxxxxxxxxx
>>>I heard that it's possible to use Sql Mobil with the full .NET framework
>>>2.0 from the desktop. Can somebody point me in the right direction where
>>>I can find more info?
>>>
>>> Thanks,
>>> --Ader.
>>>
>>
>>
>
>
.
- Follow-Ups:
- Re: Sql Mobil (SqlCE 3.0) and Full Framework
- From: gonzalez
- Re: Sql Mobil (SqlCE 3.0) and Full Framework
- References:
- Sql Mobil (SqlCE 3.0) and Full Framework
- From: gonzalez
- Re: Sql Mobil (SqlCE 3.0) and Full Framework
- From: Ginny Caughey [MVP]
- Re: Sql Mobil (SqlCE 3.0) and Full Framework
- From: gonzalez
- Sql Mobil (SqlCE 3.0) and Full Framework
- Prev by Date: Re: Sql Mobil (SqlCE 3.0) and Full Framework
- Next by Date: SQL CE to SQL Server 2005 Express
- Previous by thread: Re: Sql Mobil (SqlCE 3.0) and Full Framework
- Next by thread: Re: Sql Mobil (SqlCE 3.0) and Full Framework
- Index(es):
Relevant Pages
|
