Need advice on getting SQL CE Server data to the desktop using VB.Net 2005 CF 2.0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Loogie - 29 Jun 2007 10:43 GMT

Hello

I am using SQL Server CE VB.Net 2005 compact framework 2.0

So I have my data on the device now I need to use it on the desktop. I
do not care what format the desktop database is in as long as I can
access it using VB.Net 2005 code.

I will be creating an application for the desktop that will take the
data collected on the device and process it on the desktop.

I do not require replication, in fact I prefer not to have it. So how do
I proceed? What is the most practical way to proceed? This app will be
used by people without access to SQL Server. It would be excellent if
this could be done stand-alone but I do not know the best course to take.

Please provide advice.

Thanks

Reply to this Message

Maciej Wolniewicz - 29 Jun 2007 14:43 GMT

Hi,

you can use in your application SQL Server Compact Edition( I'm not sure but
I think it is SQL Server CE 3.0, please correct me if I'm wrong), it can be
used both in CF2 and also on desktop, so the same database file can be used
on device and on desktop. You can simply copy database from device to
desktop or replicate them somehow to desktop.
More information about SQL Compact Edition you will fimnd on Microsoft site.

Regards,
Maciej Wolniewicz

> Hello
>
[quoted text clipped - 17 lines]
>
> :L

Reply to this Message

Loogie - 29 Jun 2007 15:52 GMT

> Hi,
>
[quoted text clipped - 7 lines]
> Regards,
> Maciej Wolniewicz

I think it is now called SQL Server 2005. I have just downloaded it and
am installing.

Thanks

Reply to this Message

Loogie - 29 Jun 2007 17:09 GMT

>> Hi,
>>
[quoted text clipped - 16 lines]
>
> :L

erm make that SQL Compact Server 2005 DOH!

Reply to this Message

William (Bill) Vaughn - 29 Jun 2007 18:48 GMT

Actually, it's "SQL Server 2005 Compact" or "SQL Server 2005 Compact
Edition". Yes, I think you're on the right track but I found the MS
documentation a bit thin. I would take a look at my EBook on the subject.

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)
-----------------------------------------------------------------------------------------------------------------------

>>> Hi,
>>>
[quoted text clipped - 19 lines]
>
> :L

Reply to this Message

Need advice on getting SQL CE Server data to the desktop using VB.Net 2005 CF 2.0

Free Magazines